sold to | store | no of trainings | no of trainings compelted | %per store |
x | A | 2 | 1 | 50% |
x | B | 2 | 0 | 0% |
x | C | 2 | 2 | 100% |
y | D | 2 | 0 | 0% |
y | E | 2 | 0 | 0% |
z | F | 2 | 2 | 100% |
z | G | 2 | 2 | 100% |
No of trainings, no of trainings completed and %per store are measures of a table(tc_training_master) and now i want to calculate average of( %per store). for the above example output should be 50%
Solved! Go to Solution.
@Kiran98480 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.
and also this one worked for me
Average = AVERAGEX(VALUES(tc_training_master[store]),[%per store]) this worked for me.
@Kiran98480 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.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
214 | |
49 | |
45 | |
45 | |
41 |
User | Count |
---|---|
263 | |
211 | |
103 | |
77 | |
66 |