2 Fact Table With 1 Bridge Table has unique Value

Question

I am will be using Excel Slicer to filter , Fact table 1 is having all the values and Qty date etcs Fact table 2 is having region or location , So wanted I all the value or qty in fact table of update when I click anything in the slicer fact2.

anonymous · Answer

Hi&nbsp; VikcyD&nbsp;,
&nbsp;
Here are the steps you can follow：
1. Create measure.
Flag =
var _select=SELECTEDVALUE('Fact Table2'[Primary Key])
return
IF(
    NOT(HASONEFILTER('Fact Table2'[Primary Key])),1,
    IF(
    MAX('Fact Table1'[Primary Key]) = _select,1,0)
)
2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

If I have misunderstood your meaning, please provide your pbix without privacy and desired output.
&nbsp;
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

vikcyd · Answer

Thanks for you Response but Will it be going to work if I am having Same File in Excel Power Pivot , Attached a Reffence file That Might Help to undsetdnad my Query&nbsp;