cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sjensen Regular Visitor
Regular Visitor

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

Accepted Solutions
jthomson New Contributor
New Contributor

Re: Numbers in equations

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

5 REPLIES 5
sjensen Regular Visitor
Regular Visitor

using numbers in equations

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. 

Phil_Seamark Super Contributor
Super Contributor

Re: Numbers in equations

HI @sjensen

 

 

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!

sjensen Regular Visitor
Regular Visitor

Re: Numbers in equations

I am getting an error. 

jthomson New Contributor
New Contributor

Re: Numbers in equations

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

sjensen Regular Visitor
Regular Visitor

Re: Numbers in equations

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 234 members 2,864 guests
Please welcome our newest community members: