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

goncalogeraldes's avatar
goncalogeraldes
Super User
4 years ago

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