Forum Discussion

o-johnralphp's avatar
o-johnralphp
Advocate I
6 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
    6 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
Super User
6 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
    Advocate I
    6 months ago

    Thanks for expanding my knowledge in DAX! Much appreciated