Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Total is not coming correct

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