SSRS - : How to make a conditional formatting for matrix by group? I currently have a report produces a matrix, displayed per user group.  (1 user group per page, with 35 user groups/pages)
I want to highlight the row in pink in this condition:
=IIf(Fields!CountFailures.Value&gt;=1,&quot;Pink&quot;,&quot;White&quot;)

However, it is not showing any colour.  Please help! (I am using PowerBI Report Builder... should be same as SSRS)
If you are formatting cells based on group totals and not a row value, you need to use an aggregate and indicate the correct row group scope.  In this sample, &quot;UserName&quot; is the name of the row group scope on the Row Groups section of the Grouping pane
=IIf(Sum(Fields!CountFailures.Value, &quot;UserName&quot;) &gt;=1, &quot;Pink&quot;, &quot;White&quot;)