Column Total does not match

Hi, 

I need your help.  I have a Purchase Price Variance report where I needed to show in a table:

These items are sourced from the same source table 'me2l' with a date range of 1 Jan 2021 to present 21 July 2024

1.  Date Range - 1 Jan 2024 to 21 July 2024

1.  Material item - sourced from "me2l"

2.  Last year's average unit price - New Measure = Net Price per Unit LY = CALCULATE(AVERAGE('me2l'[Net Price per Unit]),DATEADD('DATE TAB'[Date],-1,YEAR); sourced from "me2l"

3.  This year's average unit price - New Measure = Net Price per Unit = [Net Price]/[Price unit], sourced from "me2l"

4.  This year's total ordered quantity - sourced from "me2l"

5.  Currency - sourced from "me2l"

6.  Exchange Rate - sourced from "me2l"

7.  PPV Total = difference between 2 & 3 x 4 x 6.  Unfortunately, the column total is incorrect when I download it in Excel and compare it.   See New Measure = PPV TOTAL = SUMX(values('me2l'[Material]),[PPV Unit Price 2])*round(average('me2l'[Exchange Rate]),4).  Where, another New Measure is created PPV Unit Price 2 = CALCULATE(AVERAGE([Net Price per Unit])-[Net Price per Unit LY])*sum('me2l'[Order Qty-adj])

See screenshot:

Unfortunately, the column total in PPV TOTAL doesn't jibe or is incorrect when you download it in Excel and validate the total column.

May I seek your assistance please in solving it.  Much appreciated!

Noel Cacnio

Email: [email protected]