Same value in every row and total

[zuzannak]

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?

[HamedM1125 · Accepted solution]

@zuzannak Just change the relationship from single to both in cross filter direction!

[zuzannak]

Thanks, that helps 🙂

[HamedM1125]

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!

[AilleryO]

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 ?

[zuzannak]

Here is the link to file https://app.box.com/s/k3yjuxdib1g6begvhxgyw3k83qq9d8aw