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])) )

amitchandak's avatar
amitchandak
Super User
4 years ago

Pbiuserr , Not very clear, check if one of the two can help

 

calculate(max(FctTable[Category]) ,TOPN(1,allselected(FctTable[Category]),[Change]), values(FctTable[Category]))

 

or

 

calculate([Change] ,TOPN(1,allselected(FctTable[Category]),[Change]), values(FctTable[Category]))

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])) )