Issue with Many to Many

[wilson_smyth]

Im trying to solve a many to many challenge without using a many to many join & without using bi-directional filters.

I have the following tables:
Dim Users - distinct list of users

Dim Reports - distinct list of reports

Fact Reports - table of reports that are submitted by users

The difficulty comes when creating a "Dim ThirdPartyNumber" table.

This table contains 3rd party ID's for users of which there can be many.
So the relationships are:

[Dim ThirdPartyNumber] *------1[Dim User]1-----*[Fact Reports]*-----1[Dim Reports]

If i create a table, i can drag on fields from [Third rdParty User], [Dim User] & [Fact Reports].
When i drag on a field from Dim Report however the report breaks.

I can fix it by enabling bi directional filters throughout the model, but i really want to avoid this.
Are there any other suggestions on how to handle this?

Ive included an example PBIX, located here:

https://1drv.ms/u/s!AgldA0VQfPV9hNQwgO3ZeCJ5J9IKuA

Appreciate any expertise provided, thank you.

[MattAllington]

I don’t understand what you are saying here.  Can you please clarify

---

@wilson_smyth wrote:

If i create a table, i can drag on fields from [Third rdParty User], [Dim User] & [Fact Reports].
When i drag on a field from Dim Report however the report breaks.

---

[wilson_smyth]

mostly, i will be using the third partyID in a slicer but users may want to add it to a table to link it with the Report Name, shown below.

Paul	Report 1	5000001
Paul	Report 2	5000001
Paul	Report 3	5000001
Paul	Report 1	5000002
Paul	Report 2	5000002
Paul	Report 3	5000002
Mary	Report 4	5000010
Mary	Report 5	5000010
Mary	Report 4	5000011
Mary	Report 5	5000011
Frank	Report 6	5000020
Frank	Report 7	5000020
Frank	Report 8	5000020
Frank	Report 9	5000020
Frank	Report 6	5000021
Frank	Report 7	5000021
Frank	Report 8	5000021
Frank	Report 9	5000021
Frank	Report 6	5000022
Frank	Report 7	5000022
Frank	Report 8	5000022
Frank	Report 9	5000022