Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone
While I related three tables and tried to make a chart to count distinct values, but something strange happened.
Can someone kindly help here? Thank you!
The data sample:
The result:
Solved! Go to Solution.
Seems like you are missing a table relationship or something.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Seems like you are missing a table relationship or something.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thank you for your hint about incorrect relationship.
I found that I have to adjust the relationship from "Many to One - Single" to "Many to One - Both"