Forum Discussion
Helper IIINot getting desired granularity between two fact tables
Hello,
I have two fact tables with Many to Many cardinality. I have defined a relationship on Store+Zip field and set filter direction as Single (Table 1 filters Table 2). My Slicer in on Zip from Table 1 while Mail Qty is from Table 2.
At the highest level (Store), i am getting correct Mail Quantities but when i drill-down to zip level, instead of getting zip-wise quantities, the store level figure is getting repeated for all the zips. Attaching images for clarity.
Any help will be highly appeciated.
Thanks,
2 Replies
- amitchandak
Super User
Velocity , if they are still M-M then try bridge table
https://www.seerinteractive.com/blog/join-many-many-power-bi/
VelocityI tried the bridge table but unable to get the desired result. My base table is To_Be_Mailed Table but i need to show data from Mailed table also in the same visual. If I deselect a zip in the slicer, i want value in To_Be_Mailed_Qty column to be 0 (as the zip has been deselected) but Already_Mailed_Qty should show the correct value as that is historical data and you do want to show that data. However, entire row gets removed for the deselected zips.
Here is the link to pbix file.
https://1drv.ms/u/s!AlAhec3copzOkj-8j5mUi9zz9Ppl?e=s36tP3
Thanks,
