Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |