Forum Discussion

sps-reporter's avatar
sps-reporter
Icon for Helper II rankHelper II
6 years ago
Solved

Wrong answer ... going crazy ... must be simple?

I've built a "fake" call center performance report and the answers are not coming out as expected. I am looking  find the total amount of time on the phone for the call center on 3 different shifts f...
Need Help
sps-reporter's avatar
sps-reporter
Icon for Helper II rankHelper II
6 years ago

Greg_DecklerI think your original tip is exactly my problem. I'm just not sure how to apply it. Can I use a measure in summarize?

m_Total 2 =
VAR __table = SUMMARIZE('Table1',[Category1],"__value",[m_Single])
RETURN
IF(HASONEVALUE(Table1[Category1]),[m_Single],SUMX(__table,[__value]))
Every row in this screen shot is correct except the total row.
Not sure how to proceed with the tip you provided. Thanks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

sps-reporter Yes, you can use a measure in SUMMARIZE. 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.