Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

intervals

Hello everyone!   I would like to see how many of measures falls into interval 0-10 min; so I wrote code as can be seen at the top but for some reson for 5 min still shows "0" even thou it should g...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous you have to also check for blanks()

     

    Measure 2 = 
IF 
( [Measure] == BLANK(), BLANK(), 
IF ( [Measure] < 10, 1,
0
)
)

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous are you adding this as a measure or column, it should be added as a measure.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

parry2k  When I use measure then my claculated time is not visible and I get "1" everywhere 

 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous you have to also check for blanks()

     

    Measure 2 = 
IF 
( [Measure] == BLANK(), BLANK(), 
IF ( [Measure] < 10, 1,
0
)
)

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡