Forum Discussion

leerjones85's avatar
leerjones85
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...
Need Help
  • Fowmy's avatar
    Fowmy
    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

     



Fowmy's avatar
Fowmy
Super User
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

 



  • leerjones85's avatar
    leerjones85
    Frequent Visitor
    1 year ago

    Thank You, this worked.