How to measure two matrix from two table

[Anonymous]

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 as the user can select month to check the differences 

I use this formula for the differences

VAR __BASELINE_VALUE = SUM('Compare by Route'[Revenue])

VAR __MEASURE_VALUE = CALCULATE(SUM('Current'[Revenue]), 'Current'[Period] IN { "TODAY" })

RETURN

    IF(

        NOT ISBLANK(__MEASURE_VALUE),

        DIVIDE(__MEASURE_VALUE - __BASELINE_VALUE, __BASELINE_VALUE)

    )

But it doest give the correct output as I check with the same route It does not gave 0 %

[mwegener]

Hi @Anonymous ,

can you post a screenshot of the modelview.

[Anonymous]

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

[mwegener · Accepted solution]

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]

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.