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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

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! It's time to submit your entry.

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

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.