Forum Discussion
How can I multiply two columns in a visualization?
I'm trying to calculate estimated dividend income (ending values * dividend yield) for each position in a visualization. Ending values is the SUM of the investment per position. Dividend yield is from a different table. Position is the link between tables. Dividend yield is not an aggregate.
Struggling to figure this one out. Would greatly appreciate the help. Thank you very much!
Hi, Anonymous
You can try the following methods.
Measure:Result = SUM('Investment Report'[Ending Values])*SELECTEDVALUE('Asset Master_Detail'[Dividend yield])Is this the result you expect? If not, please provide more details.
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.
2 Replies
Hi, Anonymous
You can try the following methods.
Measure:Result = SUM('Investment Report'[Ending Values])*SELECTEDVALUE('Asset Master_Detail'[Dividend yield])Is this the result you expect? If not, please provide more details.
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.