Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
87 | |
72 | |
68 | |
63 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |