Forum Discussion
GROUP BY and COUNT
kiril see the attached solution, tweak it as you see fit.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡
Community Championyou can add +0 to your measure
or you can check for blanks,
measure name = if(isblank(measure),0, measure) which will bascially to check if its blank and if so make it 0.
However that might not work for all scenarios. If you want to use time intelligence, you need to use a date table with continues values (ie no missing values), you can also then join to that date table your date and can return where there is no date.
So join your date field twith a relationship to your date table and then pull the date back from the date table with the measure that checks for blank or returns a +0
hope that makes sense.