Forum Discussion

Pbiuserr's avatar
Pbiuserr
Post Prodigy
4 years ago
Solved

Syntax issue with TOPN argument TABLE

Hello. I have a measure which retrive name of category which has max [Change] value. I'd like to add another dimension to that - not only category, but also a gender and filter it to be female. so ...
Need Help
  • Pbiuserr's avatar
    Pbiuserr
    4 years ago

    I've resolved my problem by using formula

     

    CALCULATE( MAX(FctTable[Category]), TOPN(1, FILTER( SUMMARIZE (FctTable, FctTable[Gender], FctTable[Category], "@Chng", [Change]), FctTable[Gender] = "Female"), ABS([Change])) )

Pbiuserr's avatar
Pbiuserr
Post Prodigy
4 years ago

Hi Amit
I'd like to create such table virtually and retrive "Category" with max value for gender = "Female". "Change" is a measure, not column if it helps

Pbiuserr's avatar
Pbiuserr
Post Prodigy
4 years ago

I've resolved my problem by using formula

 

CALCULATE( MAX(FctTable[Category]), TOPN(1, FILTER( SUMMARIZE (FctTable, FctTable[Gender], FctTable[Category], "@Chng", [Change]), FctTable[Gender] = "Female"), ABS([Change])) )