Forum Discussion
Amrselim1989
3 years agoHelper II
Use column in a variable Table
hello guys,
i have a problem that is soooo frustrating to me,
whenever i copy a DAX code that uses a variable table, then reference a column of this variable table inside another variable it works so fine for them, but when i tried to use the same syntax, it just doesn't work for me ?!!!!!!!
Driving me crazy !!!!!!!!
what is wrong here ?!!!
VAR SourceTable = ADDCOLUMNS ( ALL ( Sales[ItemCode] ), "@Amt", [Sum of Net Sales Value] )
VAR Result = RANK ( DENSE, SourceTable, ORDERBY ([@Amt], DESC) )
VAR _Table = ADDCOLUMNS ( ALL ( Sales[ItemCode] ), "@tank", RANKX ( ALL ( Sales[ItemCode] ), [Sum of Net Sales Value],, DESC, DENSE))
VAR _DisCount = DISTINCTCOUNT(_Table'[2tank])
RETURN Result & " OF TOTAL " &_DisCount
Hi Amrselim1989
Normal aggregation functions do not work with variable tables. You need to use x-aggegator. Try
VAR _DisCount =
MAXX ( _Table, [@Rank] )
2 Replies
- Amrselim1989Helper II
Thank you so much, that was helpful...
- tamerj1Community Champion
Hi Amrselim1989
Normal aggregation functions do not work with variable tables. You need to use x-aggegator. Try
VAR _DisCount =
MAXX ( _Table, [@Rank] )