% of row total

[JV]

Hi all,

I can't figure out how to get a measure of the '% of row total' that you can select for a value in a matrix. (Like in the bottom matrix in the picture in this post)

I need a measure because I want to multiply the measure (percentage per month per category) with a target per category(!), so I can get the target per month per category based on the division of sales, as shown in the bottom matrix.

I've anonimised the measure below, so that's why some text is grey / it might not make sense.

For context: Sales table contains categories, and I've linked those to a dimension (DIM) table.

[v-yinliw-msft]

Hi @JV ,

Could you please explain that how you get this matrix and how do you calculate the percentage?

And what do the two tables look like?

And you can also try this function to change the sub total :ISINSCOPE()ISINSCOPE function (DAX) - DAX | Microsoft Learn

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.