Forum Discussion
Multiply rows within same table
Hi, How should a measure be written where each row in a table should be multiplied with a specific row from same table. In this simplified table B and C should be multiplied with A. And the colu...
Hi, Anonymous
Measure:
Total = IF(HASONEVALUE('Table'[Date]),[Measure],SUMX('Table',[Measure]))Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I managed to get the multiplying to work, now I am just struggeling with the column subtotals, I need the subtotal to add up all the results, not price x volume . This seems to be a commin problem with DAX?
Do you want to sum Result column?
Yes, I want to sum the results from the all individual months, I do not want the column subtotal to be calculated as [price] x [volume].
where are the months. i only can see december
That was just a snapshot, here are
4 months.