Forum Discussion

SIBI1998's avatar
SIBI1998
Helper I
4 years ago
Solved

If condition Using Then

Hi Team,             If Sum(Act Ucc Cnt) >= 5 then I need an Output as Greater than 5 ,              If Sum(Act Ucc Cnt) < 5 and Sum(Act Ucc Cnt) >=1 then I need an Output as Less than 5 .   Ho...
if condition
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi SIBI1998 ,

     

    Try this:-

    Measure = 
Switch(true(),
Sum(Act Ucc Cnt) >= 5,"Greater than 5", 
Sum(Act Ucc Cnt) < 5 && Sum(Act Ucc Cnt) >=1,"Less than 5"
)

     

    Thanks,

    Samarth

apatwal's avatar
apatwal
Helper III
4 years ago

Hi SIBI1998 

 

You can try the below DAX to create a measure:

Result = 
    SWITCH(
        TRUE(),
        SUM('Table'[Act Ucc Cnt]) >= 5,"Greater than 5", 
        SUM('Table'[Act Ucc Cnt]) < 5 && SUM('Table'[Act Ucc Cnt]) >=1,"Less than 5"
    )

 

Thanks..