Connecting Tables shows sum of all values

[Anonymous]

Hi All

I am trying to pull data from a seperate table based on two variables, the Date and the Fleet number. The issue I am getting is the information is being summed instead of pulling through per day/fleet number.

See beow my relationships

Below is what I get if I use Date only

and this is what I get if I use both

This is what the main table looks like (Daily Production)

and this is what the table I want to extract the data from looks like (Diesel_Issue)

[Anonymous]

Good Day

That doesn't appear to work, and I can't really share the file without sestivive information due to amount of relationships created, and I suspect my issue is with the way my relationships are connected. If there is a way to share the file privately to you we can do that.

See a full screenshot of them below. 

If my relationship is set to "Fleet Number", it seems to give the sum of the total liters, but allows me to filter between the "Site", "Type", Fleet Number", etc.

If I change the relationship to the "Date" instead, it filters correctly, but it seems to break all other connectivity and I can no longer apply filters such as "Site", "Type", Fleet Number", etc. The only filter I can apply is date. (Focus on the top left table)

[v-chenwuz-msft]

Hi @Anonymous ,

You can try put 'calendar'[date] and 'Diesel_Issue'[fleet number] in the table visual, Liters with Don't summarize

if it does not wok, please share your pbix file without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

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