topic Re: If condition Using Then in DAX Commands and Tips

If condition Using Then

SIBI1998 — Mon, 07 Mar 2022 09:44:56 GMT

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.

Re: If condition Using Then

Samarth_18 — Mon, 07 Mar 2022 09:49:24 GMT

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

Re: If condition Using Then

goncalogeraldes — Mon, 07 Mar 2022 09:51:24 GMT

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

Re: If condition Using Then

apatwal — Mon, 07 Mar 2022 09:55:18 GMT

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