Forum Discussion

o-johnralphp's avatar
o-johnralphp
Icon for Advocate I rankAdvocate I
8 months ago
Solved

Switch Logic Error

Hi All!   Could not figure out why Switch function is giving off wrong result. Rule Group Column Data Type is already set as Decimal both in the query and table.  Yet Rule Group 1.1 is returning ...
Switch Logic Error
  • cengizhanarslan's avatar
    cengizhanarslan
    8 months ago

    In DAX, && is evaluated before ||. So your last rule:

    "[Rule Group] = 3.4 && [Age_on_Encounter] < 730 || [Age_on_Encounter] > 6935" 

     

    is actually interpreted as:

     

    "( [Rule Group] = 3.4 && [Age_on_Encounter] < 730 ) || ( [Age_on_Encounter] > 6935 )".

     

    So you could try the formula isntead for the last condition:

    [Rule Group] = 3.4 && ( [Age_on_Encounter] < 730 || [Age_on_Encounter] > 6935 )

     

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
8 months ago

In DAX, && is evaluated before ||. So your last rule:

"[Rule Group] = 3.4 && [Age_on_Encounter] < 730 || [Age_on_Encounter] > 6935" 

 

is actually interpreted as:

 

"( [Rule Group] = 3.4 && [Age_on_Encounter] < 730 ) || ( [Age_on_Encounter] > 6935 )".

 

So you could try the formula isntead for the last condition:

[Rule Group] = 3.4 && ( [Age_on_Encounter] < 730 || [Age_on_Encounter] > 6935 )

 

o-johnralphp's avatar
o-johnralphp
Icon for Advocate I rankAdvocate I
8 months ago

Thanks for expanding my knowledge in DAX! Much appreciated