Highlighting background comparing to total

[deannapi]

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 solution]

Hi @deannapi ，

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]>[total],"red")

(3) Setting the Conditional Format and then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[lbendlin]