Divide / multiply by a fixed figure

[asjam86]

My customer has a monthly figure 300000 and it needs to be divided by a coloumn which shows how many working days are in that month. Literally

300000 / working days in a month = Daily whatevers

Why is this so hard to do? It's a fixed figure, it hasn't changed in 15years and to have to create a table etc just for 1 calculation of 1 figure seems a bit overkill. I've searched google high and low but it appears to me that unless it's referencable in a table PowerBi won't let you do it. Unless I'm missing something completely obvious (not unrealistic).

Thanks in advance.

[parry2k]

@asjam86 i didn't understood your question. it should not be very hard. can you share sample data and what you want to achieve as the final result.

[asjam86]

Literally

300000 / Workingdays = 

WorkingDays = CALCULATE(sum('date'[IfWorkDay]))

I can't seem to find a way to do this as it wants to reference a field. 30000 doesn't exist in a field it's a static figure.

[parry2k]

@asjam86 assuming your workingdays formula is correct:

you can do this:

WorkingDays = 
VAR workingDays= CALCULATE(sum('date'[IfWorkDay]))
VAR fixedValue = 30000
RETURN
DIVIDE( fixedValue, WorkingDays)

[asjam86]

For some reason this is multiplying not dividing?

I've taken the variable: fixedvalue to 1 and it multiplies itself by the amount of working days. (Working days are showing correctly).

[parry2k]

@asjam86 can you share the output of your result, it is very hard to figure out what is going on, and if possible provide the sample data .

[asjam86]

As you can see, I have adjusted the value to 1 and I've asked it to divide 1 by the amount of working days in the month. Instead it's multiplied it? 

[parry2k]

@asjam86 I just did the same thing and it works fine, can you share your pbix file or provide the sample data your are working on so that I can take a look