Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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! 🤠
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |