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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

This looks great.  Filters should in the vast majority of scenarios come from the dimension tables.  That filter choice then flows down into the fact tables.  If you filter on a fact column that choice can not (and should not) propagate back up into the dimension.

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

lbendlin 

Thank you so much again!

I updated PBI as much as I can.

Updated PBI look very well designed, I think.

Now, I think I am ready to get any feedback from you regards to how to display zeros on the "Actual" tab for Kyle.

I have updated my PBI file here.

 

 

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

    I would prefer you don't do that. Instead, enable "Show items with no data".