Solved: Data Modelling Help

Abhishekjsrwala · ‎03-02-2024

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 · ‎03-02-2024

@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! 🤠

View solution in original post

Daniel29195 · ‎03-02-2024

@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! 🤠