Forum Discussion
Solved
Fields
I have two table: which reveal GrossTurnever=Q-ty*ProductPrice for every year and Margin=GrossTurnever2-GrossTurnever1
First picture below shows bi-directional relationship between tables.
Second picture shows measure for year 2016.
Hope help you.
Best regards,
You will can use Treatas pattern. It provides virtual relationship between tables.
Try do this:
http://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
Can you reveal in my example?