sumx total - not rolling up correctly

[bdaumPZN]

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.  

[Greg_Deckler · Accepted solution]

@bdaumPZN This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also, you might find MM3TR&R helpful: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...