Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am looking for a measure I could write that would be an AVERAGE of the monthly totals. When I do an average for the column, it's giving me an average of each entry vs. the average of the monthly total. Looking to get an average of the monthly totals.
Solved! Go to Solution.
@jcastr02 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.
https://1drv.ms/u/s!Ava_12t7CNJtkRJxsfw9eIcdVKck?e=3TRwgq
@Greg_Deckler Thank you for your help. I tried to do first measure but struggling to get it to work - ARe you able to see my BI file? on the %Attrition by Month page -Data is coming from the HC and Terms table. Thanks so much.
@jcastr02 - Maybe:
Measure = AVERAGEX(SUMMARIZE('HC and Terms',[Month],"__Count",SUM([Count])),[__Count])
Thank you this worked! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |