Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

How to display zero using Measure or column value (when there is no value)?

I am trying to display two zero (0) value for a line where it has column data and measure values.   I have this bottom measure which does not display anything because there is no value for [Ave Cen...
Need help with DAX
JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
2 years ago

lbendlin 

Thank you so much for your feedback. I think first option is not my option at this moment.

How do we go about doing with the second options (using disconnected tables and cross joins)?

Thanks.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523