Forum Discussion

Belindah's avatar
Belindah
Frequent Visitor
2 years ago
Solved

Need DAX formula for New Report

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 t...
Need Help
  • Belindah's avatar
    Belindah
    2 years ago

    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)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Belindah
Frequent Visitor
2 years ago

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)