Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Using OR function in a DAX expression for a measure

Hello,   In my BI solution I have following tables: Checking PK ID TYPE A B C D 1 1 T1 0 0 0 1 2 1 T2 1 1 1 0 3 1 T3 1 1 0 1 4 2 T1 0 0 0 1 5 2 T...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hello,

     

    I found a solution for the measurment.

     

    Yes_No =
    SWITCH( MIN(Code_Descriptions[PK]),
    "01", IF(SUMX(Checking,Checking[A]) >= 1, 1, 0),
    "02", IF(SUMX(Checking,Checking[B]) >= 1, 1, 0),
    "03", IF(SUMX(Checking,Checking[C]) >= 1, 1, 0),
    "04", IF(SUMX(Checking,Checking[D]) >= 1, 1, 0)
    )
     
     
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello,

 

I found a solution for the measurment.

 

Yes_No =
SWITCH( MIN(Code_Descriptions[PK]),
"01", IF(SUMX(Checking,Checking[A]) >= 1, 1, 0),
"02", IF(SUMX(Checking,Checking[B]) >= 1, 1, 0),
"03", IF(SUMX(Checking,Checking[C]) >= 1, 1, 0),
"04", IF(SUMX(Checking,Checking[D]) >= 1, 1, 0)
)