Conditional formatting based on rules and colors

i Have following sample data- Name timestamp Work Area order picks abc 10-Feb A 2 abc 10-Feb B 3 abc 10-Feb A 2 abc 11-Feb A 3 dec ...

amitchandak
3 years ago
learner03 , Create a measure like

color =

var _m1 = calculate(distinctcount(Table[Work Area]) )

var _m2 = calculate(distinctcount(Table[Work Area]), filter( Table,Table[Work Area] = "A") )

return

if(_m1 -_m2, "Red", "Blue")

Use in conditional formatting using field value option
Ahmedx
3 years ago
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/GAoVf
you can write measure like this