Matirx Visual in Power BI

[Anonymous]

Hello Friends 
I have a matrix visual which has stepped layout with +/- icon for power bi 

as you can see above 
when i open these + icon it will show second category and its total as shown below 

and when user opens second categories + icon it will show the unit category level which has background color for cell depending on a conditional formating rule as shown below 

But here you can see in second image even when i havent opened the second +icon it is not showing row total in some places but it is showing some background color 
as you can see below with red circles that its not showing row subtital but background color which i set up for cell color from conditional formating
from vbelow you can see issue is the red circle while it shoyld be someting like green circle

please help
@GuyInACube 
@amitchandak 
@lbendlin 
@Aldrin 
@aj1973 

@v-jiascu-msft 
@v-jianboli-msft 

[amitchandak]

@Anonymous , Not sowing subtotal can be because of row context used in measure like

if(Max(Item[Category]= "ABC"

or if you have used hasonevalue, isfiltered or isinscope

For that, you have to share the measure used.

Usually, we fix row context issues by creating a new measure on top of your column with all applicable group bys (row/column field).

Sumx(Summarize(Fact, Dim[Col], Dim2[Col], "_1", [Measure), [_1])

[Anonymous]

Hello @amitchandak 
as i have 52 columns in matrix as of 52 weeks of year ,
i am using calculated column for every week for conditional formating 
example 

colorweek 18 =

SWITCH(

    TRUE(),

    RELATED(sales[Week18])=1 && RELATED(sales[type])="A", 1,

    RELATED(sales[Week18])=1 && RELATED(sales[type])="B",2,

    RELATED(sales[Week18])=1 && RELATED(sales[type])="C",3,0)


and the week is also a column 
like 

Week18 =

var wek = 18            

var b = IF(sales[status]="ongoing" || 'sales'[status] = "about to start",

            IF(

            sales[startdate] <= ((TODAY()+(7*(Wek-1))) - WEEKDAY(TODAY()+(7*(Wek-1)),1)+ 1)+7

                && 'sales'[enddate] >= (TODAY()+(7*(Wek-1))) - WEEKDAY(TODAY()+(7*(Wek-1)),1)+ 1 ,1,0),0)

return b

[Anonymous]

@GuyInACube 
@amitchandak 
@lbendlin 
@Aldrin 
@aj1973 

@v-jiascu-msft 
@v-jianboli-msft 

[Anonymous]

Please help 

@amitchandak