Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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.
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.