Hi Super Users, Need help in building Relationship Via date filters Params and Calendar Date

[Skiran]

Hi All,

I have a requirement, where in the date filters Params which is created from Fact table should get filtered when I try to select any date from the calendar date. I am trying to get a solution without using a use relationship for the Base KPI dax. Instead, I need to get the results by using only those 2 filters(One is Slicer Date, the second is Filter Date). I need when the selection of Filter date is made as Actual Goods Movement, and whichever date range I select from the calendar date it should get filtered in the below columns Power Bi

Below I have attached the Screenshot for better understanding:

Note: From the Calendar date there is an active relationship to the Delivery date of the fact table. However, the other relationship of the ActualGoods Movement date is an inactive relationship from the fact table.

[amustafa]

See if this video will help you solve your scenerio. Else I need sample data and expected outcome to solve this for you.

How to use USERELATIONSHIP to handle MULTIPLE DATES in Power BI / DAX Basics 2021 (youtube.com)