Cross filtering visuals based on a measure in another visual

[JW_PBI_fan]

Hello Community,
I am having trouble figuring out what I have done wrong here.  Hopefully, someone can help me find my error. 

Background:
In this report, I am looking at overdue invoices.  I almost done, but I have a problem filtering the other visuals in the report when using the highlighted visual below (Reminder Levels).

The funny thing is, I am able to filter the reminder levels using all other visuals in the report (Clustered Bar Chart, Pie Chart, and Matrix), but not the other way around.

Here is a look at the semantic model/relationships and the table that this is based on:

I would be happy to receive any feedback.

[Anonymous]

Hi  @JW_PBI_fan ,

You can check the following:

1. You can check if the "None" flag is selected in the Format - Edit interactions, which will prevent the table from filtering another table.

2. Consider whether the measure used in the visual object are properly set to allow filtering. Some measure (depending on their DAX formula) may not filter other visual objects as expected.

3. Check to see if there are any filters set up on Visual itself that might interfere with the cross-filtering functionality.

4. You can check out the restrictions related to table-to-table relationships in the official link:

Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

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.

[JW_PBI_fan]

Hello @Anonymous ,

I have tried this several ways and still cannot figure out why the filtering won't work.
Below, you can see that the interactions are allowed for the respective visuals, there are not filters affecting either visual, and I tried using SUM and SUMX for the DAX calculation, but none of this has produced results:


Regarding the cardinality, I have also tried to adjust this with a 'lookup' table to induce a 1:n relationship and this also did not help:

Thanks for your help so far.  I am completely baffled and hope that you or someone else can shed some light on this.