Forum Discussion
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 give me "1". Can anyone help?
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.⚡
3 Replies
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 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.⚡