Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Can someone help, as I'm struggling with what I think is basic measure. I'm using a matrix table to produce the following table, but I cannot get the percentages to work. The table will show me the correct values, when I try convert them to a %, it is not working.
For each person I need to show how the proportion that is 'above' and 'at or below' target for each area. All the data is in one table, with the following fields:
Area = RegionArea
Target = TargetResult
Person = SalesPerson
Result = Count (numeric)
Area | Target | Person 1 | Person 2 | Person 3 | Person 4 |
Area 1 | At or Below | 52.3% | 29.9% | 7.3% | 0.3% |
Above | 47.7% | 70.1% | 92.7% | 99.7% | |
Area 2 | At or Below | 93.7% | 62.2% | 62.8% | 20.0% |
Above | 6.3% | 37.8% | 37.2% | 80.0% | |
Area 3 | At or Below | 81.9% | 63.0% | 16.5% | 13.5% |
Above | 18.1% | 37.0% | 83.5% | 86.5% | |
Area 4 | At or Below | 94.9% | 95.6% | 33.8% | 1.6% |
Above | 5.1% | 4.4% | 66.2% | 98.4% |
Can anyone help?
Solved! Go to Solution.
Hello @Saes,
Can you please try this:
1. Create a Base Measure for Count:
Total Count = SUM(Table[Result])
2. Calculate the Percentage
Percentage =
DIVIDE(
[Total Count],
CALCULATE([Total Count], ALL(Table[TargetResult]))
)
With these measures and setup, you should be able to achieve the desired output. Should you require my further assistance, please do not hesitate to reach out to me.
Hello @Saes,
Can you please try this:
1. Create a Base Measure for Count:
Total Count = SUM(Table[Result])
2. Calculate the Percentage
Percentage =
DIVIDE(
[Total Count],
CALCULATE([Total Count], ALL(Table[TargetResult]))
)
With these measures and setup, you should be able to achieve the desired output. Should you require my further assistance, please do not hesitate to reach out to me.
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |