Forum Discussion
Issue with Many to Many
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...
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
