Filtering Across Visuals Not Responding Correctly

[andybamber]

Hello Community! 

Hoping you can help with a problem I have...

I have a systems table with various details of IT systems. Also in that table is a system created date and a system retired date. I have the system created date linked to a date table with an active relationship , and the system retired date is also linked to the date table with an INACTIVE relationship.

I have a line chart to show a count of systems created and systems retired over time. I use to measures:

Systems_Created = CALCULATE(count(System[Full Name]),FILTER(System,System[Created in System Master Catalog]>=DATE(2021,05,01)))

Systems_Retired = CALCULATE(count(System[Full Name]),USERELATIONSHIP(System[Retired in System Master Catalog],Date_Table[Date]))

The data plots correctly. I also have a table and what this is supposed to show are details of the systems with create and/or retired dates, and depending where you click on the line chart it should render accordingly.

However... The only way the table will show the correct details is if i include the 2 measure above in the table.

How can i get the table to show the correct data without having to include the 2 measures.

Secondly, if i click on one of the categories in the line chart, say Systems Created, even with the 2 measures in the table it fails to render correctly

[Anonymous]

Hi  @andybamber ,

You can check whether there is a relationship between your table and the table. Even if you define a relationship in the measure, but there is no actual relationship between the two tables or the filtering direction is Single, the visual objects will not interact.

This is the related document, you can view this content:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

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.

[amitchandak]

@andybamber , I think you have to use both measures as we can not pass date used in measure in filter to handle that in second visual

[andybamber]

Hi @amitchandak I thought that was going to be the case... i'll just have to hide those columns or turn them into some kind of indicator for the user that makes them think it was deliberate lol