Forum Discussion
Velocity
Helper III
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 fr...
amitchandak
Super User
Super UserVelocity , if they are still M-M then try bridge table
https://www.seerinteractive.com/blog/join-many-many-power-bi/
VelocityHelper III
Helper IIII 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,