How to remove roll-up totals inside the Matrix table

[Anonymous]

I am using the Matrix so that Managers can do a drill through to see Resources Allocation % based on their Product > Project > Release > Person .   However the Matrix visual does the roll up total which when using % is inaccurate totals so I would like to do a drill down that only  shows the % at the lowest level (Person).   See what I mean in image:

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We could try to use the following measure to meet your requirement, use ISINSCOPE can the level is in what column filed, then we can return the result or blank.

Result =
IF ( ISINSCOPE ( 'Table'[People] ), [YOUR_ORIGIN_MEASURE], BLANK() )

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.