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

You need to do a lot of work on your data model before you can think of that

 

 

 

You need to create a Facilities dimension table and then merge it with the trend and occupancy tables. Then you need another PayerType dimension , and then youcan connect your dimensions to your fact without the need for a joinkey table.

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

lbendlin 

I was working pretty much all day with relationships.

I thought that "joinkey" table would work, but I will definitely restructure my relationship tomorrow based on your suggestions and let you know where I am at.  Thank you so much!!

 

BTW, what do you mean by "merge"?

Do I have to combine two tables (like "trend" and "occupancy" tables) or you meant connect with Facility dim table with "trend" and "occupancy" tables?