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.

v-zhangti's avatar
v-zhangti
Community Support
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.