Forum Discussion

Yian's avatar
Yian
Frequent Visitor
3 years ago
Solved

Measure total incorrect

Dear Community,   I have the following measure written for a calculation involving two columns from two tables with a many-to-many relationship.   The first table is the 'Transactions Breakdown ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Yian 

     

    You can try the following methods.

    Measure 3 = IF(HASONEVALUE('Ownership mapping'[Client]),[Measure 2],[Measure])

    Is this the result you expect? If not, please provide the output 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.

amitchandak's avatar
amitchandak
Super User
3 years ago

Yian , multiplication needs to be done at row level and then needs to be summed up. if not possible then use common columns

 

preferably from common dimension/on visual columns

 

Sumx(Values(Dim[Column]), CALCULATE(SUM('Transactions Breakdown'[Total]) * MAX('Ownership mapping'[Client Ownership])) )

 

Use summarize for more than one column

Yian's avatar
Yian
Frequent Visitor
3 years ago

Hi,

 

Thanks for the reply. But the solution didn't work out. I just edited my original post and added more information. Please take a look. Thanks very much!