Forum Discussion

rauldip22's avatar
rauldip22
Frequent Visitor
8 years ago
Solved

How to select a top filtered value from a table with DAX

Hello! I need a DAX consult to select a Gender with the max Amount from my table filtered by a Category. With SQL ir should be: SELECT TOP 1 Gender FROM TableName WHERE Category = "A" ORDER BY Amou...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    rauldip22

     

    Or you can hardcode it for Category A as follows

     

    Measure 2 =
TOPN (
    1,
    VALUES ( TableName[Gender] ),
    CALCULATE ( SUM ( TableName[Amount] ), TableName[Category] = "A" ), DESC
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi rauldip22

 

Try this MEASURE...It will give you the Gender with Highest Amount according to category or cases that you select

 

Measure =
TOPN (
    1,
    VALUES ( TableName[Gender] ),
    CALCULATE ( SUM ( TableName[Amount] ) ), DESC
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

rauldip22

 

Or you can hardcode it for Category A as follows

 

Measure 2 =
TOPN (
    1,
    VALUES ( TableName[Gender] ),
    CALCULATE ( SUM ( TableName[Amount] ), TableName[Category] = "A" ), DESC
)
  • rauldip22's avatar
    rauldip22
    Frequent Visitor
    8 years ago

    Thanks!!! It Works!