cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Power Participant

## Count values from measure.

I have multiple measures that work through a number of steps to figure out if a "Country" is "Within KPI", "Expected KPI Met" and "KPI Breached".

Final Measure...

(17) KPI Met =
VAR KPIMet =
IF('KPI Measures: Minimum Staffing Levels'[(13) Actual Staffing Level %] >= 'KPI Measures: Minimum Staffing Levels'[(16) 99% of (14) MSL], "Expected KPI Met",
IF('KPI Measures: Minimum Staffing Levels'[(13) Actual Staffing Level %] >= 'KPI Measures: Minimum Staffing Levels'[(15) 95% of (14) MSL] && 'KPI Measures: Minimum Staffing Levels'[(13) Actual Staffing Level %] < 'KPI Measures: Minimum Staffing Levels'[(16) 99% of (14) MSL], "Within KPI",
"KPI Breached"))
Return
KPIMet

I now need to create charts showing stuff like "How many  Expected KPI Met, Within KPI and KPI Breached, but as these values are being created from a measure, I cant use the measure for charts.  How can I get a count of each value from the measure?  I tried creating a new table with Region and Country and then the above measure as a calculated column, but its now work (see below).  How can I use the measure results for charts and calculations.

2 REPLIES 2
Super User

Hi,

I am not sure how much i can help but i would like to try.  Share the download link of the PBI file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

@StuartSmith 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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors