Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
@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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
57 | |
50 | |
44 | |
21 | |
19 |