Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Divide function

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

3 Replies

  • Vinit's avatar
    Vinit
    Frequent Visitor
    3 years ago

    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's avatar
    daXtreme
    Solution Sage
    3 years ago

    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's avatar
    tamerj1
    Community Champion
    3 years ago

    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?