topic Re: How to apply Measure in Dax Studio in DAX Commands and Tips

How to apply Measure in Dax Studio

thangmcsa — Sun, 21 May 2023 04:45:26 GMT

Hi All,

I would like to add a rank column for virtual table created by Dax function, my code as below

DEFINE MEASURE Sales[sale_amount] = sumx(Sales, Sales[Quantity] * Sales[Net Price]) var temp = SUMMARIZECOLUMNS ( Customer[Country], "Sales Amount1",Sales[sale_amount] ) EVALUATE ADDCOLUMNS(temp, "rankx",rankx( Customer[Country], Sales[sale_amount] ) )

I got the error say "Table variable name 'temp' can not be used in the current context because a base table is expected" , this mean Rankx function can not work with virtual table created by Dax code ??

Dataset used in the lab from this link Introducing RANKX in DAX

Re: How to apply Measure in Dax Studio

Jihwan_Kim — Sun, 21 May 2023 05:55:21 GMT

Hi,

Please try something like below.

DEFINE MEASURE Sales[sale_amount] = SUMX ( Sales, Sales[Qualtity] * Sales[Net Price] ) VAR temp = SUMMARIZECOLUMNS ( Customer[Country], "Sales Amount1", Sales[sale_amount] ) EVALUATE ADDCOLUMNS ( temp, "rankx", RANKX ( VALUES ( Customer[Country] ), Sales[sale_amount] ) )

Re: How to apply Measure in Dax Studio

thangmcsa — Sun, 21 May 2023 08:10:08 GMT

hi Jihwan_Kim ,

The code provided work as well, however could you please help clarify why we can not use the code below ?

"rankx", RANKX ( VALUES ( temp[Country] ), temp[Sales Amount1] )