I have a table with arrival and departure dates, I would like to have the total counts displayed

[rpedere96]

I am having trouble because when using the date slicer I noticed that the total counts are all the same no matter what date range is selected.

does it have something to do with this?

one of the relationships is represented by a dotted line

[v-xiaotang]

Hi @rpedere96 

it may have something to do with your measures, [total Arrival] & [total Departure].

what's the content of your current 2 wrong measures? and what's your expected result?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[rpedere96]

sample_data 

sheet 1 - fact table
sheet 2 - joined table using date keys

[mussaenda]

Hi @rpedere96 

first, we don't know in which table your date is coming from.

same with the value that you are counting.

If I will base on the screenshot you provided, I am assuming it is a relationship issue.

If you could provide a sample data, we can help you better.

Check your table relationships.

Hope this helps.