multiplication

2 Topics

Dax Formula returning weird error when multiplying from two tables
There are two tables Invoice detail and Rewards; with many - one relationship. Need to create a dax measure two multiply two columns Quantity from Invoice detail and Reward amount from Rewards Table. Total Rewards = SUMX('invoicedetail', ('invoicedetail'[quantity] * RELATED('Rewards'[Reward_Amount]))) used this dax but it is returning the wrong output. It is multiplying a quantity by itself and multiplying it to rewards resulting in wrong output. Wrong output : It would be great if I could get any help. Thank you in advance
smehra88
3 years ago Place DAX Commands and Tips
755Views
0likes
3Comments
DAX with multiple filters and multiplication
Hi all. I need to create a measure where a sum of two location : 1) Penang, 2) Japan, are sum up together and multiply with value 88. There are also a restriction/filter where the category must be RM. I've tried this formula : Cost_Saving_JPN = CALCULATE(SUMX('Actual Data',[Actual Hours]),FILTER('Actual Data', 'Actual Data'[Position] = "RM" && 'Actual Data'[Project Location]= "Penang" && 'Actual Data'[Project Location] = "Japan")) * 88 But the output becomes blank. If I use below formula, then the output is there. Cost_Saving_JPN = CALCULATE(SUMX('Actual Data',[Actual Hours]),FILTER('Actual Data', 'Actual Data'[Position] = "RM" && 'Actual Data'[Project Location] = "Japan")) * 88 Please enlighten me on this. Thank you!
Solved
Anonymous
5 years ago Place DAX Commands and Tips
1.4KViews
0likes
1Comment