Filtering visuals in a report with multiple dates in fact table

[LaurensTPS]

Hi All, 

This will be my first post reaching out to the community. I have used multiple solutions described on the forum, so thanks to all who take part in solving our problems! 

I've been trying to fix a report I'm building for our company. 


I would like to be able to compare the orderintake with the planned delivery date. We extract our date from an excel model, which is imported into a FACT table in Power BI (As seen in the screenshot). 

In the report page I would like to be able to click in the Orderintake visual (on the left), filtering a specific month (for example July 2022), and then filter the visual Orderboek (on the right). By doing so I'd like to see when an order is put into our system, and being able to see when it will be delivered. 

The visual on the right uses the Actual Planned Delivery Date as the date, which is the active relationship. 

The visual on the left uses the Orderdatum as the date, which comes from an inactive relationship (as displayed in the screenshot).  

Orderintake uses the following DAX Measure: 

Orderintake = CALCULATE(sum('FACT-Orderregel'[Turnover realistic]), USERELATIONSHIP('DIM-Kalender'[Date],'FACT-Orderregel'[Orderdatum]))

Orderboek uses the following dax measure: 

Orderboek planned = calculate(sum('FACT-Orderregel'[Turnover realistic]), 'FACT-Orderregel'[Status]= "Orderboek", USERELATIONSHIP('DIM-Kalender'[Date],'FACT-Orderregel'[Actual PLanned Delivery Date]))

When I click in the orderintake visual, the orderboek visual responds by only displaying orders with orderdates from july (as seen in the screenshot). I'd like to see the orderboek show the visual with orders based on the actual delivery date. The table in the bottom of the page seems to be working. Is there a solution to this? 

Thanks in advance 🙂

[amitchandak]

@LaurensTPS , use this measure in visual level filter and check for non blank values -Orderboek planned 

Check if that can help