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.

     

     

Baskar's avatar
Baskar
Resident Rockstar
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.

 

 

Ramakrishna's avatar
Ramakrishna
Regular Visitor
7 years ago

Hi Bhaskar,

 

can you help me with this query how to achive with DAX.

 

IF [repair information ] = "Repeat Repair"

THEN

IF COUNTD([VIN]) / TOTAL(COUNTD([VIN])) > 0.1
THEN round(COUNTD([VIN]) / TOTAL(COUNTD([VIN])),4) END

ELSE

IF COUNTD([Strata Claim Id]) / TOTAL(COUNTD([Strata Claim Id])) > 0.1
THEN round(COUNTD([Strata Claim Id]) / TOTAL(COUNTD([Strata Claim Id])),4) END

END

 

any quick response would be appriciated.

 

Regards,

Ram.