Forum Discussion
data modeling problem
i want to calculate the sales(subtotals) for top 5 product names but give me the same result
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)
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