I have multiple tables with hundreds of rows in each sharing the same date/time. I put a slicer on my report to filter and SUM the rows with the matching dates. However, the visual only returns the value of the first row with the matching date, not the sum of all the rows with that date..... Not sure what I might be doing wrong? I made a "many:many" both direction relationship between my calendar table and the data table.