Filtering report using USERELATIONSHIP measures with Charts

Hi Anonymous 

My assumption is that you want to create two separate visualizations that are filtered independently: one for orders created by creation date and one for open orders created by delivery date. Additionally, you want to have a table that shows both creation and delivery dates without applying filters to the chart that affect both measures.

Here are my suggestions.

First, make sure your calendar is properly connected to both. You can do this by using a function to clear the filter context for a specific column. For example:

Document Date = CALCULATE(
                    FIRSTNONBLANK('Open Orders'[Creation Date],1),
                    ALLEXCEPT('Open Orders', 'Open Orders'[Doc.compra])
                )

Delivery_date = CALCULATE(
                    FIRSTNONBLANK('Open Orders'[Delivery Date],1),
                    ALLEXCEPT('Open Orders', 'Open Orders'[Doc.compra])
                )

These measures should retain the filter context but remove any other filters that may have come from the chart.

You appear to have correctly set up the measure values for activating the correct date relationships for each chart. If filtering one chart affects another chart, it may be because the filter context is propagated through the report. To prevent this, you can modify the visual interaction of the chart:

Select the first chart.

Go to the Format tab in the Visualizations pane.

Find and click "Edit Interactions".

You will see icons appear on other visuals, click the "None" icon on the visuals you do not want to be affected by the first chart.

Repeat these steps for the second chart, making sure to prevent it from filtering the first chart and table.

If you still have problems, it is best to provide the pbix file and be careful to delete sensitive data.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.