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 color the values with the same color of the background JUST FOR THE FIRST ROW , can anyone provide a solution please ? 

 

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]) )

2 Replies

  • vojtechsima's avatar
    vojtechsima
    Super 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]) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Firas_Belgouthi 

     

    Another approach is to conditionally format the text color for every value field. Create a measure similar to the one provided by vojtechsima but make it return the color value which is consistent with the background color. Then format all value fields with this measure, selecting Apply to Totals only. 

    Blank Row Color = IF(SELECTEDVALUE('Table'[Category])="" && NOT(ISFILTERED('Table'[SubCategory])) && ISFILTERED('Table'[Category]), "#000000")

     

     

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!