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