Forum Discussion
Power BI Model help needed
Hi sentsara ,
I have looked at your issue and the questions is about the relationships and the fact that you have some details that are in one of the table but not on the other one, in this case the lowest detail of infomration at program category.
The fastest way is to add the rows that you need on the Revenue at risk but without any values, in this case for the MEDICAID IBR and CPU and for Medicare UTL only add the Population and the measure leave the rest of the fields in blank.
If this is not possible please tell me and I can try and check another soluiton.
All the measures won't be available in Revene at risk table. Only the measures which have goals , will be having entry to this table. I just put some sample records , but in practical large data will be there.
main table here is HEDIS ( Fact). All measures will exists here. so we need to correct the solution to pickup all data from HEDIS And left join with revenue at Risk table ( for picking up program category,program , state program,goal)