Forum Discussion
Helper IPercentage Measure by Row Category
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?
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.
1 Reply
- Sahir_Maharaj
Super User
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.