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.
Hello!
I am trying to build a report which shows CRM data accuracy per user. For each user there is a rule with either a blank (not relevant), N (not correct) and a Y (correct). I use the following formula to work out each users % accuracy:
Summary 1 % = CALCULATE(COUNTA('Data 1'[Value]),'Data 1'[Value]="Y")/(COUNTROWS('Data 1')-(COUNTBLANK('Data 1'[Value])))
Data is the list of data and [Value] is the Y/N/Blank. This works perfectly however I want to disply this on a radar chart and show the max percentage for each catagory to show the best/most accurate for each rule. I'm trying to search for a way to do it but I am not having much luck at all.
Simplified example of the Data:
Entity | User | Rule | Value |
Company 1 | Bill | 1 | N |
Company 2 | Bill | 1 | Y |
Company 9 | John | 1 | Y |
Company 10 | John | 1 | N |
Company 17 | Rob | 1 | Y |
Company 18 | Rob | 1 | Y |
Company 3 | Bill | 2 | N |
Company 4 | Bill | 2 | N |
Company 11 | John | 2 | Y |
Company 12 | John | 2 | Y |
Company 19 | Rob | 2 | N |
Company 20 | Rob | 2 | Y |
Company 5 | Bill | 3 | N |
Company 6 | Bill | 3 | Y |
Company 13 | John | 3 | Y |
Company 14 | John | 3 | N |
Company 21 | Rob | 3 | Y |
Company 22 | Rob | 3 | N |
Company 7 | Bill | 4 | Y |
Company 8 | Bill | 4 | N |
Company 15 | John | 4 | N |
Company 16 | John | 4 | Y |
Company 23 | Rob | 4 | N |
Company 24 | Rob | 4 | N |
Expected retun:
Rule | Value |
1 | 100% |
2 | 100% |
3 | 50% |
4 | 50% |
With this I could drop it onto the Y axis of the radar chart (with Catagory being the Rule number) to allow me to dynamically filter a copy of the data to show individuals against the best value in each. This will also stop the radar from changing the order of the rules based on the highest value as this will be static.
Thanks!
Solved! Go to Solution.
You may add an additional measure as follows.
Measure = MAXX ( SUMMARIZE ( 'Data 1', 'Data 1'[User] ), [Summary 1 %] )
You may add an additional measure as follows.
Measure = MAXX ( SUMMARIZE ( 'Data 1', 'Data 1'[User] ), [Summary 1 %] )
Amazing, thanks Sam. Works a treat.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |