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.
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
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |