Forum Discussion

Firas_Belgouthi's avatar
Firas_Belgouthi
Regular Visitor
1 year ago
Solved

SUB TOTAL MATRIX ISSUE

Hello Power BI community , i have a pborlem with this matrix , i have two parents , one is X and the other is Empty , for the empty i don't want to see the sub totals , i want to hide the row or to c...
Need Help
  • vojtechsima's avatar
    vojtechsima
    1 year ago

    Hello, Firas_Belgouthi ,

    not perfect, but you can try this:

    _sum_hidden = 
IF( 
    ISINSCOPE('Table'[dim]) && ISBLANK( SELECTEDVALUE('Table'[dim])) 
    && NOT(ISINSCOPE('Table'[dim_two])) 
    // here add the same NOT ININCOPE for your other columns that are presents in the matrix
    , BLANK(), SUM('Table'[sum]) )
vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
1 year ago

Hello, Firas_Belgouthi ,

not perfect, but you can try this:

_sum_hidden = 
IF( 
    ISINSCOPE('Table'[dim]) && ISBLANK( SELECTEDVALUE('Table'[dim])) 
    && NOT(ISINSCOPE('Table'[dim_two])) 
    // here add the same NOT ININCOPE for your other columns that are presents in the matrix
    , BLANK(), SUM('Table'[sum]) )