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.
Hi!
I've to calculate the percent of good items, see above. The Measure_Good_Perc value is a DAX measure.
Group | All_Item | Good | Measure_Good_Perc |
A | 37 | 35 | 94,59% |
B | 308 | 238 | 77,27% |
C | 51 | 31 | 60,78% |
D | 70 | 57 | 81,43% |
E | 56 | 30 | 53,57% |
F | 28 | 21 | 75,00% |
I have to make two measure which shows the minimum and maximum value of Measure_Good_Perc in the range of the groups (in this case the min is 53,57% and the max is 94,95%). The groups are dynamic, controlled by many slicers.
Thanks for the help.
@Hoszi try following two measures, it might required tweaking since dont know the whole data model/tables/relations etc.
Min Good % = MINX( VALUES( Table[Group] ), [Measure_Good_Perc] ) Max Good % = MAXX( VALUES( Table[Group] ), [Measure_Good_Perc] )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |