Measure to calculate penetration

Kasonga2018 — Mon, 12 Sep 2022 08:01:07 GMT

Hi all

I have a table that looks like this

I am trying to calculate penetration by using a measure, if I have an aggregated matrix view below

I would like to calculate penetration in such a way that segment A is always the denominator, so my final result should look like this.

Re: Measure to calculate penetration

tamerj1 — Mon, 12 Sep 2022 08:59:17 GMT

Hi Kasonga2018
Please try

Percentage = VAR Numerator = SUM ( 'Table'[Population] ) VAR Denominator = CALCULATE ( SUM ( 'Table'[Population] ), 'Table'[Segmant] = "A" ) RETURN DIVIDE ( Numerator, Denominator )

topic Measure to calculate penetration in DAX Commands and Tips

Measure to calculate penetration

Re: Measure to calculate penetration