Need DAX formula for New Report

[Belindah]

I am trying to create a card that will show the total money spent from the sum of the Device Cost column when we enter numbers in the # of Devices Installed column. I currently have a formula that is providing the sum of the Device Cost column on a card, but I can't figure out how to calculate this card. The cost per device would be $710.86 out of $3,110,129. Is there a way to do this?

[Anonymous]

Hi @Belindah ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Belindah · Accepted solution]

I actually figured it out. Sorry, my explanation was more complicated than it needed to be. I Just needed to multiply the numbers entered in one column by $710.86 to get what I needed. I was overthinking it. I used this: 

Total Y Cost = CALCULATE(SUM('table'[# of Devices Installed])*710.86)