Percentage Measure by Row Category

[Saes]

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?

[Sahir_Maharaj · Accepted 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.