Conditional Formatting based on calculation of different tables

[Heinrich]

Hello

I would like to do a conditional formatting based on calculation of 3 differen values

i.e. 

if table a is less than the value of 10

and if table b is less than the value of 5

and if table c is less than the value of 14

than put the background of table z to red

is that possible?

Regards

JFM_12

[Heinrich]

Hello Bibiano_Geraldo
Thank you very much.
Can this also be done with data which is accessed to on Direct_Query.
Greetings
JFM_12

[Bibiano_Geraldo]

Yes, try this topic if can help you. 

https://community.fabric.microsoft.com/t5/Desktop/Conditional-Formatting-Direct-Query-Different-Tabl... 

[Bibiano_Geraldo]

Yes, its Possible, Try To follow this steps:

1. Create a measure like this

Measure =

IF(

    SUM(Table_A[Your_Column]) < 10 &&

    SUM(Table_B[Your_Column]) < 5 &&

    SUM(Table_C[Your_Column]) < 14,

    1,

    0

)

2- In your table_Z, right click in values that you want to highlight and choose format condition - Background, and then choose rules and drag the created measure to fileds based on, and put something like the screen bellow

[Heinrich · Accepted solution]

Hello
Hope you had a great weekend

I tried this with following script

_Video_Poor_Percentage = IF(

    SUM(CQD[Video Local Frame Loss Percentage Avg]) > 50  &&

    SUM(CQD[Video Frame Rate Avg]) < 7 &&

    SUM(CQD[Audio Post FECPLR]) > 0.15 ,

    1,

    0

)

But received following error

The formatting looks like

Regards

JFM_12