Help with Dax to calculate at rows level!!

[LongDucVu]

Hi,

I'm trying to calculate price impact base on fact sales data:

Sales data contains sales information by invoices date, customer number and product.

My price impact formular is : (Average selling price MTD - Average selling price same month last year)* Qty current month.

The problem is the sub-category does not add up from rows level calculation.

below is my dax:  

This is the current issue I have from sample 

[LongDucVu]

@Greg_Deckler  Hi,

I read many post from you about subtotal and total calculation. Are you able to help me with this?

Many thanks!!

[LongDucVu]

Hi Amit,

Thanks a lot for your response.😀

I got all sales, qty, asp measure already but when I perform  the calculation of price impact with dax formular above does not add at at category/subcategory.

If you look at total price impact above is 79K which is in correct.

Thanks again

[amitchandak]

@LongDucVu , with help of the date table, you should be able to get the price of this month vs last month

Assume you have Avg price measure already

MTD = CALCULATE([Avg price],DATESMTD('Date'[Date]))
last MTD = CALCULATE([Avg price],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month = CALCULATE([Avg price],previousmonth('Date'[Date]))
MTD = CALCULATE([Avg price],DATESMTD('Date'[Date]))
last MTD = CALCULATE([Avg price],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE([Avg price],previousmonth('Date'[Date]))

divide([MTD] -[Last MTD], sum(Table[Qty]) )

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s