Forum Discussion

B_Real's avatar
B_Real
Advocate IV
9 years ago
Solved

if then else

Most languages have a structure that allows multiple conditions to be met in an IF statement, like this:   IF condition1 THEN result1 Else If condition2 THEN result2 ELSE result3.   Except for DA...
Tips and Tricks
  • Baskar's avatar
    Baskar
    9 years ago

    Cool my dear friend.

     

    We can do anything in DAX cool.

     

    Try this,

     

    Measure =

    Switch ( True(),

     condition1,"Result1"  ,

        condition1,"Result1"  ,

    etc...                     ) 

     

     

    let me if any help in DAX.

     

     

kalhassan11's avatar
kalhassan11
New Member
3 years ago

Hi All, 
Please if anyone can help, this is the general logic: 

IF BU selected THEN select Row that has "All" in Grade

IF Grade selected THEN select Row that has "All" in BU

IF Nothing selected THEN Select Row that has "All" in BU and "All" in Grade 

IF Both BU and Grade Selected THEN keep rows as it is 

RETURN SUM(Value)/DISTINCTCOUNT([Date])