Forum Discussion

pallavi_r's avatar
pallavi_r
Icon for Super User rankSuper User
2 years ago
Solved

Modelling and filtering issue - value getting doubled

Dear Team,   Can any one please tell me how to do the modelling for these 2 tables, so I can filter based on Rating on Power BI and I should not get sum of value doubled up because of 2 rating prov...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi pallavi_r ,

     

    I think you just need to add key columns in both tables and then create a relationship between them.

    You can edit data model in Power BI Service. Find the semantic model in your workspace and then open data model.

    Key Column = COMBINEVALUES("-",'Dimension Table'[Security ID],'Dimension Table'[Security Type])
    Key Column = COMBINEVALUES("-",'Transaction Table'[Security ID],'Transaction Table'[Security Type])

    Result is as below.

    For reference:Edit data models in the Power BI service (preview) - Power BI | Microsoft Learn

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

pallavi_r's avatar
pallavi_r
Icon for Super User rankSuper User
2 years ago

Hi bhanu_gautam , thanks for your reply. Can I create this UniqueDimensionTable  dax table in power bi service. it is ms fabric modelling panel I have to do the modelling. No desktop PBI :-(. Kindly suggest

Thanks,

Pallavi

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi pallavi_r ,

 

I think you just need to add key columns in both tables and then create a relationship between them.

You can edit data model in Power BI Service. Find the semantic model in your workspace and then open data model.

Key Column = COMBINEVALUES("-",'Dimension Table'[Security ID],'Dimension Table'[Security Type])
Key Column = COMBINEVALUES("-",'Transaction Table'[Security ID],'Transaction Table'[Security Type])

Result is as below.

For reference:Edit data models in the Power BI service (preview) - Power BI | Microsoft Learn

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.