Highlighting background comparing to total

Question

I have a matrix built by Year-Month, Location Name, and a % value from dividing 2 measures.

I want to highlight cells per column if the cell is greater than it's total

The datatable looks like the following example but with multiple years and Locations:

Year	Month	Location	Value1	Value2
2023	January	LocA	40193714.33	643966.62
2023	February	LocA	31852406.97	912116.34
2023	March	LocA	35091429.05	767218.08

Then I create a measure for Value2 / Value1

Year-Month	LocationA
2023	2.17%
January	1.60%
February	2.86%
March	2.19%
Total	2.17%

I now need to compare each row with it's column total:

IF each cell is greater than the column Total, then highlight cell red

anonymous · Accepted Answer

Hi&nbsp;deannapi&nbsp;，
&nbsp;
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create measures.
total = CALCULATE([Measure],ALL('Table'))color = IF([Measure]&gt;[total],"red")
(3) Setting the Conditional Format and then the result is as follows.