Forum Discussion

alvin199's avatar
alvin199
Icon for Helper III rankHelper III
4 years ago
Solved

Leave empty for certain row and total

Hi,

 

This is a matrix table and I would like to leave empty value from row 8th (Total job) to row 13th (Total). 

 

I have tried to switch off the Total but it is not possible as I still want to retain the Total for column 1 to 5. For the row, I cannot think off any method that can leave it empty instead of showing -100%.

 

 

 

Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi alvin199 ，

    Since I do not have your specific data, I have created a similar matrix template data：

    Matrix:(Make the red circle below empty）

    Use the below measure:

    Measure =IF (
    HASONEVALUE ( 'Table'[type] ),
    MAX ( 'Table'[value] ),
    IF (
        MAX ( 'Table'[Name] ) = "D"
            || MAX ( 'Table'[Name] ) = "E",
        BLANK (),
        SUM ( 'Table'[value] )
    )
)

    Then create visual:

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

     

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi alvin199 ，

    Since I do not have your specific data, I have created a similar matrix template data：

    Matrix:(Make the red circle below empty）

    Use the below measure:

    Measure =IF (
    HASONEVALUE ( 'Table'[type] ),
    MAX ( 'Table'[value] ),
    IF (
        MAX ( 'Table'[Name] ) = "D"
            || MAX ( 'Table'[Name] ) = "E",
        BLANK (),
        SUM ( 'Table'[value] )
    )
)

    Then create visual:

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

     

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    alvin199 , if you do want grand total for a measure you can create a measure like

     

    if(isinscope(Table[IT Jon Group]), [Measure], Blank())