Dynamic Table Visual When Using Fact and Dimension Tables

[oliverblane]

Setup

I have a fact table that looks like this:

and a dimension table that looks like:

I have created a LegendCategories table to help with the Dynamic Table visual:

Using this I am able to change the category viewed in my table visual between Location and Provider:

Issue

However, when I try viewing Establishment, the measures are not as expected:

As you can see, when partitioning by Establishment, the measures take the sum of all cases where Status = Initial/Complete, not taking into account the establishment.

My model looks like:

Here is a link to the sample PBIX file: sample.pbix

Thanks for the help!

[DataInsights · Accepted solution]

@oliverblane,

Change the bidirectional relationship to unidirectional:

[oliverblane]

Thank you, I should have noticed that!