Total is not coming correct

[mg01]

Hi Team,

Below is my dataset:

 
Below is the table visual we are creating in Power BI:

We are using below measure for Value:

Value = IF(SELECTEDVALUE('Sheet1 (3)'[measur id])="M",1000,

IF(SELECTEDVALUE('Sheet1 (3)'[measur id])="C",100,

IF(SELECTEDVALUE('Sheet1 (3)'[measur id])="E",1,1)))

The total is not coming correct for Actual Price it should be 686.20 but it coming as 3.82. Below is the measure we are creating for Actual Price:

Actual price = (DIVIDE(SUM('Sheet1 (3)'[Amount]),SUM('Sheet1 (3)'[QUANTITY]))*[Value])

Can anybody please let me know how to correct the total for Actual Price

Thanks,
MG

[ppm1]

Please see this video.

(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube

Pat