How to show column with no value in this case?

[JustinDoh1]

I am sharing my Pbix file here.

I am trying to display column called "Managed Medical Skilled" in "Budget" table.

(I have been trying to fix this for more than a day... and this task is little urgent..  😞   )

So, "Variance" table subtracts value from "Actual" to "Budget".

For example, FacilityCode 810, Hospice:

8 - 6 = 2.

1st issue:

Column "Managed Medical Skilled" column does not show up on "Budget" table.

2nd issue:

Calculation of difference for "Managed Medical Skilled" column does not show up in "Variance" table.

Main reason is that in "Budget" table, there is no data for that column.

For calculation of Variance, I created a joined key called "JoinKey", and created a relationship between two tables ("Acutal" & "Budget").

I created a separate table called "Payer" with all PayerName values.

Is there anyway to modify the relationship between "Payer" table and "Budget" table so that all PayerName values (including "Managed Medical Skilled") show up in "Budget" table (and it might possibly resolve the issue)?  

How do we go about resolving these two issue?

Thanks.

[HotChilli · Accepted solution]

Do you want the column (in Budget visual) to show with all zeroes (and use that in the variance calculation)?

I suggest deleting the relationship between actual and budget.

Create a new dimension table with the distinct values of JoinKey,Payer, Facility.  Create relationships with budget and actual tables on Joinkey.

Put Facility from this dimension table in the rows of each visualisation.

Create a measure for the Budget visual (MeasureTest = COUNT(Budget[ID]) + 0).

---

Well, that's just my quick thoughts after having a look at the pbix.

Let me know how it goes.

[JustinDoh1]

@HotChilli Thanks for help. This is a great approach. Your code on the measure (MeasureTest = COUNT(Budget[ID]) + 0) saved my day as well 🙂 .