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 All,
Please assist in the following issue.
I have the following visual matrix:
Num | Avg.Score | Max Score Single task | % Total Score | VOC LVL |
199 | 12 | 12 | 100.00% | Good |
200 | 11 | 12 | 91.67% | Good |
201 | 9 | 12 | 75.00% | Medium |
202 | 11 | 12 | 91.67% | Good |
203 | 12 | 12 | 100.00% | Good |
204 | 12 | 12 | 100.00% | Good |
205 | 7 | 12 | 58.33% | Bad |
206 | 9 | 12 | 75.00% | Medium |
207 | 12 | 12 | 100.00% | Good |
208 | 10 | 12 | 83.33% | Medium |
209 | 12 | 12 | 100.00% | Good |
210 | 12 | 12 | 100.00% | Good |
And Only the first column is column from the Data Table. All other columns are measures.
I want to create a measure to count "VOC LVL" values - Intending to know how many "Good", "Medium" and "Bad" records we have.
The problem I have is that VOC LVL is also a measure and I can not count its content because it's not a column context.
VOC LVL = SWITCH(TRUE(),[Avg.Score]>=11,"Good",[Avg.Score]>=8 && [Avg.Score]<=10,"Medium",[Avg.Score]<=7,"Bad")
Hope there is a solution. Your help will be highly appriciated.
Thanks in advance,
Solved! Go to Solution.
@George1973 , For that you have to bucket/dynamic segmentation. You need an independent table and create new measure using those
Have look at my video and file. if those can help: https://youtu.be/CuczXPj0N-k
File attached after signature
@George1973 , For that you have to bucket/dynamic segmentation. You need an independent table and create new measure using those
Have look at my video and file. if those can help: https://youtu.be/CuczXPj0N-k
File attached after signature
@amitchandak Thanks a lot!
It's was really helpful. I was also thinking about the indipended table and bins, but the measure you've provided in your video was a real breakthrough 🙂
Thanks.
@amitchandak Here is the final VOC dashboard. With your help the almost 40% of the work was done in very sufficient way.
Thanks a lot once again.
P.S. Do not get confused with the Georgian writings 🙂
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 |