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])
|
