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.

[truptis · Accepted solution]

Create a measure:
Result = var m1 = Sum(Act Ucc Cnt)
return
if(m1 >= 5,"Greater than 5", if(m1 >=1 && m1 <5","Less than 5","N.A."))

If this post solves your query, then please accept it as a solution to help other members find it faster. Also, hit a thumbs up. Thanks.

Best Regards,
Trupti S

[Anonymous]

Really helpful

[arvindsingh802]

Create a Measure 
Dummy = Sum(Act Ucc Cnt)

Then in next measure where you nee the value (I have added secound else as Less than 1)
Value = IF([Dummy] >= 5, "Greater than 5",  IF([Dummy] < 5 && [Dummy] >=1 "Less than 5", "Less than 1"))