sumx total - not rolling up correctly

bdaumPZN — Fri, 21 May 2021 16:55:49 GMT

Hi,

I am attempting to create a matrix that shows how well car sales performed during the first 14 days of being available. I'd like to show this at the car type level (SUV vs. Sedan) but also be able to show the data at the model level. For the higher level of the hierarchy (car type), the DAX code is agnostic to which model and is just summing up the car units sold within 14 days of the first date in the table for that car type. How do I get the car type to properly sum up the sales (for the first 14 days) for each specific model. In the example below, instead of the Sedan type reflecting 132 units, it should show 237.

topic sumx total - not rolling up correctly in DAX Commands and Tips

sumx total - not rolling up correctly

Re: sumx total - not rolling up correctly