Forum Discussion

Amrselim1989's avatar
Amrselim1989
Helper II
3 years ago
Solved

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 wor...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Amrselim1989 

    Normal aggregation functions do not work with variable tables. You need to use x-aggegator. Try


    VAR _DisCount =
    MAXX ( _Table, [@Rank] )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Amrselim1989 

Normal aggregation functions do not work with variable tables. You need to use x-aggegator. Try


VAR _DisCount =
MAXX ( _Table, [@Rank] )