Getting the Measures Max value of each group

Anonymous · ‎02-23-2022

Hi Team,

I need help to get Maximum value of Measure.

I used below DAX function but its give wrong output.

Target_Conversion% = CALCULATE(MAXX('Cashier,salesman & Performance',[Conversion%]),ALL('Cashier,salesman & Performance'))

Thanks for help

Greg_Deckler · ‎02-23-2022

@Anonymous This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎02-23-2022

@Greg_Deckler

Hi Greg, Thanks for replying and I have followed your suggestion and have done some work accordingly.

As I am new to the DAX, I'll be needing your suggestion. It shows the same value as Conversion%, but I require max value.

Thanks

Anonymous · ‎02-28-2022

Hi @Anonymous,

Can you please share a pbix or some dummy data and DAX expressions that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng