Conditional Formatting Measure Not Working Across rows

[Kodonnellm]

I have a conditional formatting table with the following measure applied, but not all my rows are highlighted red when they should be, any idea why that is? I have the conditional formula applied to the actual values. 

Color Indicator =
IF (
SUM ( 'FTE Portfolio Grid_Full Data_data'[Act FTE] ) > SUM ( 'FTE Portfolio Grid_Full Data_data'[Fcse FTE] ),
"red",
BLANK()
)

[Anonymous]

Hi @Kodonnellm 

I have offered a reply on your original post.

Need help with conditional formatting based on ano... - Microsoft Fabric Community

And after testing, it can work, can you provide some sample data or sample pbix that hide your sensitive information so that can provide more suggestion for you.

Best Regards!

Yolo Zhu

[Omid_Motamedise]

Use this one

Color Indicator = var x= SUM ( 'FTE Portfolio Grid_Full Data_data'[Fcse FTE] )
return IF (
SUM ( 'FTE Portfolio Grid_Full Data_data'[Act FTE] ) > x,
"red",
BLANK()
)

[quantumudit]

Hello @Kodonnellm 

To better understand the problem, please provide a sample dataset and a use case. The current description does not offer sufficient context to grasp the issue you are encountering.

Thanks,

Udit