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