(Sorry I updated original post dramatically after I realized that I had relationship created between two tables, and this question might not be directly related to DAX command only)
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.
Column "Managed Medical Skilled" column does not show up on "Budget" table.
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 in DAX or in table relationship?
@ERD I was able to finish the task with you advice. It was brilliant. I have a quesiton though. I am curious why we do not use JoinKey as a key for the dimention table, but use FacilityCode as a key. Logically, I think commom key would be JoinKey, no?