Forum Discussion

Frequent Visitor

1 year ago

Solved

Help with DAX Measure

Hi, I have a table which has 4 columns Title Potential Frequency Nearly Example 1 4 1 0 Example 2 2 0 0 Example 3 4 1 1 Example 4 1...

1 year ago

leerjones85

Not sure if I I fully understand your question, try this and let me know:

CF = 
VAR __Case1 = CALCULATE( SUM(Table01[Value]) , Table01[Col] = "Potential") = 4
VAR __Case2 = CALCULATE( SUM(Table01[Value]) , Table01[Col] = "Frequency" )  = 1
VAR __Case3 = CALCULATE( SUM(Table01[Value]) , Table01[Col] ="Nearly" )  = 1
VAR __Result = 
    SWITCH(
        TRUE(),
        __Case1, "yellow",         
        OR(__Case2, __Case3 )  , "red"
    ) 
RETURN
    __Result

Super User

1 year ago

Hi leerjones85
You can achieve this by using conditional formating in cell elements option. Just select the series name from drowdown and set rules for backgroud color. See image:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

Related content