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.
Hi,
I'm trying to show movie count for movie director however I'm getting the same value in every row and total. Any ideas how to solve it?
Solved! Go to Solution.
Thanks, that helps 🙂
May be the Movie count measure/column is causing issue. Do check the count/count distinct calculations by choosing one repeated movie in the filter!
Hi,
Is there any value in your column Director from your table Movie Director ?
The only thing we are sure about is that your problem is coming from the relationship between your tables, hence the same result on all rows.
Check your relationship and as ssson as it wiil be corrected your results will be correct.
One more thing you can try : The column where the count is made is coming from which table ?
Are you counting using a measure or just the drop down menu from your column ?
Let us know if you found a solution are can you provide us a demo file ?
Here is the link to file https://app.box.com/s/k3yjuxdib1g6begvhxgyw3k83qq9d8aw
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 |
---|---|
109 | |
106 | |
87 | |
74 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |