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 .

 

How do I got the Solution.

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

3 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    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

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