Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i joined 3 dim tables to single fact table . i used 4th table ( say filter table ) for taking filter value as input. I joined the filter table to one of the dim table . i set up many to many and cross direction relationship between three dim tables and fact table. When i see the result , only one filter get applied on fact out of three dim tables . fact table records donot get filtered by 2 dim tables . i want to propagate filter tables value to all three din tables and finally record of fact get filtered .
Solved! Go to Solution.
Please read about TREATAS