Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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! 🤠
User | Count |
---|---|
106 | |
88 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |