How can I multiply two columns in a visualization?

[Anonymous]

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!

[Anonymous]

That worked! Thank you for your help!

[v-zhangti · Accepted solution]

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.