Forum Discussion
Anonymous
3 years agoNot applicable
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
1 Reply
- ppm1
Solution Sage
Please see this video.
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat