Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
thangmcsa
New Member

How to apply Measure in Dax Studio

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 

2 REPLIES 2
Jihwan_Kim
Super User
Super User

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


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

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors