Forum Discussion
JustinDoh1
Post Prodigy
Post ProdigyHow 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...
I would prefer you don't do that. Instead, enable "Show items with no data".
lbendlin
Super User
Super UserMerge these tables
Bidirectional 1:1 between two tables usually indicates that this should be a single table.
This is not yet a dimension table. It is missing a primary key. Figure out what the primary key is and kick out/downstream anything that prevents it from working.
Avoid bidirectional *:* relationships wherever possible. They are expensive and can lead to wrong results.
JustinDoh1Post Prodigy
Post ProdigyOk. Thank you so much for your feedback.
I will work on it again tomorrow and let you know 🙂