Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show blank/Hide data for second level in Matrix Table

Hi All,   Is there a way to show blank for second level of data in Matrix Table?    Example, show blank for the entire row for C, D, A, B (sub-country)?  I do not want the user to see sub-countr...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to create these two measures to replace the original values:

     

    New Actual % = IF(ISINSCOPE('Table'[Location]),BLANK(),SUM('Table'[Actual %]))
    New % Growth = IF(ISINSCOPE('Table'[Location]),BLANK(),SUM('Table'[% Growth]))

     

    The result shows:

    Hope this can help.

     

    Best Regards,

    Giotto Zhi

     

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

Hi,

 

Please try to create these two measures to replace the original values:

 

New Actual % = IF(ISINSCOPE('Table'[Location]),BLANK(),SUM('Table'[Actual %]))
New % Growth = IF(ISINSCOPE('Table'[Location]),BLANK(),SUM('Table'[% Growth]))

 

The result shows:

Hope this can help.

 

Best Regards,

Giotto Zhi