Forum Discussion
Data Modelling Help
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?
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! 🤠
1 Reply
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! 🤠