Conditional formatting subtotals of specific column in a matrix based on subtotals of another column

[egorlinus]

Hi Experts,

 I am novice to power bi and struggling with conditional formatting subtotals of specific column in a matrix based on subtotals of another column as shown below: For example: If subtotal of column "commsn." is less than or equal to subtotal of column "laying", a green icon should be displayed next to subtotal of column "commsn." or font color should change to green. Otherwise it should turn red. Please help.

[egorlinus]

That's a perfect solution Anton,

Thanks a ton!

[egorlinus]

Thanks for prompt response Solomon.

Laying and commsn are activities derrived from DIM table Activity.

I tried to create measure with SUMX and FILTER but unable to figure out how to filter on tables with joins. I am still uncomfortable with DAX. Can I share my pbix file on your email id?

[SolomonovAnton]

of course you can feel free for send me email I sent my mail in  private message

[SolomonovAnton · Accepted solution]

hello ! 

you shoild use conditional formating based on measure. Apply condition formation only for totals

measure should looks like 

measure = if([commsn]<[laying],"green","red")