data modeling problem

[Mahmoud_Nasser]

i want to calculate the sales(subtotals) for top 5 product names but give me the same result 

[MattAllington]

My guess is the sales amount is correct, but who knows. You should try both totals in a card with nothing else. 

you could also use. CALCULATE(SUM(OrderHeader[SubTotal]),OrderDetail)

[Mahmoud_Nasser]

I made what you said but give me a different result and applied your equation on the table and give me a different result  doesn't equal the total 

[MattAllington]

Use OrderDetail[SalesAmount] instead of sub total. You can only fi,ter/summarise data by following the arrows in the model. 

[Mahmoud_Nasser]

Thanks, Matt 

i measured it by [salesamount] but doesn't give me the same result 

for example total [subtotals] = 115 M  but total [sales amount] = 98 M 

[MattAllington]

The formulas add the totals. You need to understand your data better. Pick one invoice and investigate 

[Mahmoud_Nasser]

okay, I will do 

Thanks for help matt