Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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?

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How did you format your table like that. that combinated headers?