Querying with DAX

Below some DAX queries.

EVALUATE

‘Dimension’

EVALUATE

‘Fact’

EVALUATE

‘Dimension’

ORDER BY

‘Dimension'[Id]

START AT 3

EVALUATE

CALCULATETABLE(‘Dimension’, ‘Dimension'[Col2]=”X”)

EVALUATE

ADDCOLUMNS(‘Dimension’, “TotalValue”, [TotalValue])

EVALUATE

SUMMARIZE(‘Dimension’, ‘Dimension'[Col1])

EVALUATE

SELECTCOLUMNS(

‘Dimension’,

“Column 1”,’Dimension'[Col1],

“Column 2”,’Dimension'[Col2])

EVALUATE

SUMMARIZE(

‘Dimension’,

ROLLUP(‘Dimension'[Col1]),

“TotalValue”, [TotalValue])

EVALUATE

CROSSJOIN(

ALL(‘Dimension'[Col1])

, ALL(‘Dimension'[Col2]))

EVALUATE

GENERATE(‘Dimension’, RELATEDTABLE(‘Fact’))

EVALUATE

ROW(“A”, 1, “B”, 2)

EVALUATE

TOPN(3,’Dimension’)

EVALUATE

UNION(ROW(“A”, 1),ROW(“B”, 2))

EVALUATE

INTERSECT(ROW(“A”, 1),ROW(“B”, 1))

EVALUATE

SUMMARIZECOLUMNS(

‘Dimension'[Col1],

‘Dimension'[Col2],

“TotalValue”, [TotalValue])

EVALUATE

GROUPBY(

‘Fact’

,’Dimension'[id]

,”TotalValue”, SUMX(CURRENTGROUP(), ‘Fact'[Value]))

WITH

MEASURE ‘Fact'[TotalValue1] = SUMX(‘Fact’, ‘Fact'[Value])

SELECT

{[TotalValue1]} ON COLUMNS,

[Dimension].[Id].MEMBERS ON ROWS

FROM [Model]

DEFINE

MEASURE ‘Fact'[TotalValue] = SUMX(‘Fact’, ‘Fact'[Value])

EVALUATE

ADDCOLUMNS(

SUMMARIZE(

‘Dimension’

,’Dimension'[Id])

, “TotalValue”, [TotalValue])

Leave a Reply

Your email address will not be published. Required fields are marked *

*

code