If condition Using Then

[SIBI1998]

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 .

How do I got the Solution.

[apatwal]

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..

[goncalogeraldes]

Hello there @SIBI1998 ! Try the following:

Measure_Name =
VAR _act_ucc_cnt =
    SUM ( 'Table_name'[Act Ucc Cnt] )
RETURN
    SWITCH (
        TRUE (),
        _act_ucc_cnt >= 5, "Greater than 5",
        _act_ucc_cnt < 5
            && _act_ucc_cnt >= 1, "Less than 5"
    )

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[Samarth_18 · Accepted solution]

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