Data Modelling Help

[Abhishekjsrwala]

I have 3 tables:

Product: 1M rows, all distinct

Anaplan: 18k rows, all distinct

Shipped table: 3M rows, 100k distinct

All joined on ISBN/Codr field from their respective tables

The relationship between them is as below:

 

I need to divide Initial shipped from Shipped table with Budget from Anaplan table and plot against Imprint from Product table. 

I have 5+ years experience in Power BI, but I am not able to figure this out why this calculation is always giving out incorrect results. Is this model even going to give me correct results? 

[Daniel29195 · Accepted solution]

@Abhishekjsrwala 

change the bi-directional filters to single direction filters from product to both tables , since base on the calculation you are trying to achieve, you dont need for these bi directional +  --> bi directional  could be the cause of the incorrect resuts you are having . 

let me know if this works for you .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠