topic Re: DAX Divide function in DAX Commands and Tips

DAX Divide function

Anonymous — Wed, 05 Oct 2022 11:18:25 GMT

I want to divide, Count(items.length) / workingDays. { Count(item.length) = count of different product, and Working days = No. of days betwwen two selected dates }

for that I wrote DAX function

Measure 4 = DIVIDE(CALCULATE(COUNT('Production of the day'[productshortname])),VALUES('Production of the day'[actualendtime]))

but it doesn't show any result. I even make separete measure for Count and Values of working days and divide these measure by making another masure. but it didn't work.

What is going wrong.? How should i make it correct.?

Re: DAX Divide function

tamerj1 — Wed, 05 Oct 2022 11:54:58 GMT

Hi Anonymous
VALUES is a table function. What are expecting the following argument to return

VALUES('Production of the day'[actualendtime])

What is the content of the 'Production of the day'[actualendtime] column?

Re: DAX Divide function

daXtreme — Wed, 05 Oct 2022 12:12:22 GMT

Anonymous

Each DAX function has input arguments with their correct types and output with the correct type. When you pass something to a function, you have to obey the rules of syntax and types. It's like in mathematics: you can't expect that adding a set to a number will yield something meaningful - they are different objects and the "+" operation is not defined for them. VALUES, as already pointed out, is a TABLE FUNCTION, not a scalar, so you can't put it under DIVIDE which expects 2 scalars.

You probably fish for something like:

[Measure 4] = DIVIDE( DISTINCTCOUNT( 'Production of the day'[productshortname] ), DISTINCTCOUNT( 'Production of the day'[actualendtime] ) )

If you're not sure about a function, go to http://dax.guide and look for it (there's a Search box on the left-hand side). Then pay attention to the input and output.

Re: DAX Divide function

Vinit — Fri, 07 Oct 2022 06:05:30 GMT

I want DAX formula for Divide,

it's like, Measure = No. of product / (no. of days between two dates - 1 - No. of Sundays in selected period)

Measure =

COUNT('Production of the day'[productshortname]) / (VALUES ( 'Production of the day'[actualendtime] )- 1 - no. of sundays)

how should i write Correct fromula for this.

Here is context of each term,

No. of product = COUNT('Production of the day'[productshortname]),

no. of days between two selected dates = (VALUES ( 'Production of the day'[actualendtime] ),

1 = totals selected no. of days minus 1 day ( 10 -1=9; 10 - totals selected no. of days between dates ),

No. of Sundays in selected period = no. of sundays( how should i write DAX for no. of Sundays between selected date only)