Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Numbers in equations

In a powerbi measure can I use numbers to be multiplied by columns.

 

for example: count(Total[total hired])*(2,000)

 

it is not working as I have it but is there a way to have it work?

 

 

1 ACCEPTED SOLUTION
jthomson
Solution Sage
Solution Sage

If there's actually a comma in 2,000, try removing it

View solution in original post

5 REPLIES 5
jthomson
Solution Sage
Solution Sage

If there's actually a comma in 2,000, try removing it

Anonymous
Not applicable

thank you that was the issue, lol simple fix..

Phil_Seamark
Microsoft Employee
Microsoft Employee

HI @Anonymous

 

 

When you say it isn't working.  Are you getting a result that is different from what you are expecting?  Or are you getting an error?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Anonymous
Not applicable

I am getting an error. 

Anonymous
Not applicable

Can I have a number within a measure that is multiplied by something else:

for example:

 

Count(Total[total hired])*(2,000) 


That equation did not work but hopfully if gives you an idea. 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.