Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to remove roll-up totals inside the Matrix table

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 wh...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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.

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

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.