Forum Discussion

Regular Visitor

6 years ago

Solved

Multiply a column by another result

Hi Guys, Can you help me again please? I'm trying to gain a solution to show a % result (Margin) from a Joint venture? The main data currently shows FULL margin so I wanted to add in a c...

Nishantjain
6 years ago
john_whelan Try this DAX measure

Margin JV = SUMX('Data','Data'[Margin CTD] * RELATED('Joint_Venture'[JV]))

Any questions,let me know

Thanks
Nishant

Regular Visitor

6 years ago

Hi,

Hopefully these screen shots will help?

All I'm looking to do is create a second results calculation.

That will be called Margin AFTER JV %

so for eg. Company 210 will have a result of 50% of 2,815,855.04 so will be 1,407,927.52

Hope this makes sense?

Continued Contributor

6 years ago

john_whelan Try this DAX measure

Margin JV = SUMX('Data','Data'[Margin CTD] * RELATED('Joint_Venture'[JV]))

Any questions,let me know

Thanks

Nishant

john_whelan
Regular Visitor
6 years ago
Nishantjain Solution is perfect!

Thanks very much!