Forum Discussion
john_whelan
6 years agoRegular Visitor
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...
- 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
Nishantjain
Continued Contributor
6 years agojohn_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
6 years agoRegular Visitor