Forum Discussion
Solved
Get a category name with minimum value
Hello, The measure down below shows how to get category name with maximum value CALCULATE( MAX(Fct_Table[Category]), TOPN(1, FILTER( SUMMARIZE ( Fct_Table, Fct_Table[Gender], Fct_Tabl...
Pbiuserr TRy this Measure
MINX ( SUMMARIZE ( Table, Table[GroupBy] , "Measure1",[YourMeasure] ), [Measure1])
Else refer this accepted solution:
1. Create a measure for getting max of the change:
MaxChange = CALCULATE(MAX(Fct_Table[Change]), ALL(Fact_Table))
2. Create another measure to get the category with max change:
MaxCategory = CALCULATE(MAX(Fct_Table[Category]), FILTER(Fact_Table, Fct_Table[Change] = [MaxChange]))
Same goes with finding minimum category, create another set of measures and replace MAX with MIN
Yes but the table in this scenario must consist Fct_Table[Gender] and Fct_Table[Category] and its need to be sorted by [Change] measure. Can you help me build such measure?
Edit: Change is not a Fct_Table[Change], its a measure
