Sales price via direct query shows incorrect total / subtotal

[Jonas_Holm]

Hello,

I have this problem, that whenever I try to calculate sales, it doesn't show the correct total sales.

Below is what the expected result should have been like:

under names I have these items:

name = haircare and perfumes

order_id = 2005114916 and 2005114915

product_id = 76039, 87848 etc.

Can anyone help?

[v-stephen-msft · Accepted solution]

Hi @Jonas_Holm ,

You could first create a measure like

Measure = IF(ISINSCOPE('Table'[product_id]),SUM('Table'[base_price_ex_tax])*[Qty Measure])

Then create another measure to sum up.

Sales = SUMX('Table',[Measure])

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.