Forum Discussion
Power BI Model help needed
Hi sentsara ,
I have one question regarding your dataset you have on measure CCS two values for Goal is that correct?
I created two tables one for population and another for the Measures then related this two tables with the others:
Since using a matrix will summarize the information on the values and you have goals for the same measure you need to make one workaround that is to place the goal on the rows also, if you need to have it on the values, then you must also pace it on the values and reduce the size of the column goal:
On the second image you can see the table with the goal hidden:
Hi Miguel FĂ©lix,
Thanks for taking your time and providing me the solution.
I still need to get IBR ,CPU and UTL Measure with the compliance Rate in the Matrix.
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)