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:
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
View solution in original post
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"
Many to One SingleMany to One Single OutputMany to One BothMany to One Both Output
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!