Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 fro...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

     

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

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.