Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have the data model as follows:
SamJam has keys from both the tables Sam and Jam. That way a Many-to-Many relationship is established between Sam and Jam through SamJam.
Jam is related to Pam by a One-to-Many relationship.
Sam and Pam do not have a direct relationship.
Now, when I try to create a basic table chart using SamName and Count of PamID, I get all the wrong values., i.e., all the values are shown as below.
How to get the exact Count of PamID by SamName?
Any help is greatly appreciated. Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous ,
Could you have tried to modify the relationship between Jam and Pam from single to both? If it could not help you, could you please share a sample file to have a test if possible?
Regards,
Daniel He
Hi @Anonymous ,
Could you have tried to modify the relationship between Jam and Pam from single to both? If it could not help you, could you please share a sample file to have a test if possible?
Regards,
Daniel He
Hi @Anonymous ,
Could you please share your pbix file to have a test if possible?
Regards,
Daniel He
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |