DAX Divide function

[Anonymous]

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.?

[Vinit]

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)

[daXtreme]

@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.

[tamerj1]

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?