Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to measure two matrix from two table

I have two matrix. One is a current and one is base. I want to get the percentage differences  betwen the curent and base filter by route/destination. Both of the table have relationship with Month...
Need Help
  • mwegener's avatar
    mwegener
    5 years ago

    Hi Anonymous ,

     

    these are just two tables with an inactive Many to Many relationship.

    Your data model should have dimension tables and fact tables.

    Your two tables are fact tables, but you need dimension tables (date/calendar, route/destination) for filtering. These should have a 1 to many relationship to the fact tables. 

    Take a look here.

    https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

     

    If you provide sample data, I can help you with the modeling.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This is my model view. I actually reference the Compare by Route to the Current

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hi Anonymous ,

 

these are just two tables with an inactive Many to Many relationship.

Your data model should have dimension tables and fact tables.

Your two tables are fact tables, but you need dimension tables (date/calendar, route/destination) for filtering. These should have a 1 to many relationship to the fact tables. 

Take a look here.

https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

 

If you provide sample data, I can help you with the modeling.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you very much.

    I made the dimension table and use the  dimension table for the row and matrix for the comparison and now my data as per intent.