The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Guys,
I have a calculated column which return me blank values, because a I have a lot of blank rows in a column.
Considering this DAX:
What function should I use to eliminate or add 0 to these blank rows?
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous ,
You might try wrapping this in an If - IF(your whole measure = null),0 , your whole measure)
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
You might try wrapping this in an If - IF(your whole measure = null),0 , your whole measure)
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
User | Count |
---|---|
27 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |