Forum Discussion
Doing a rank with a column created in variable
Hi everyone, I need to rank the Sales of the Employees, but I have a table and a new column called Test created as a variable in th DAX. This is to improve the performance. I have tried it withou...
Dangar332
Resident Rockstar
Resident Rockstarhi, Anonymous
try below
Measure =
VAR table_ =
ADDCOLUMNS (
SUMMARIZE (
'TableEmployee',
'TableEmployee'[Employee],
"Sales", 'TableSales'[Sales]
),
"Test", [Sales]
)
RETURN
RANKX(table_ ,[test],,ASC,Dense)
or
measure =
rank(
crossjoin(
all('TableEmployee'[Employee]),
all('TableSales'[Sales])
),
orderby([sales],asc)
)Hi! Thanks for your reply! The first option is not working because the newly created column and table cannot go just like this in the Rankx. That is why I usd SUMX() but I only get 1s for every row. And the second option is not working either, and also referring to the measure Sales, which is wanted to avoid. Do you have any other suggestions?
- Dangar332
Hi, Anonymous
provide some data