Forum Discussion
Solved
DAX help
I need convert the following sql to DAX. Basically I need count distinct taskID, which is created before 20180101 with In progress and not started status. select count(distinct (taskID)), count(*...
this is what you need
taskBegDay3 = VAR _selected = SELECTEDVALUE('Date'[Date (bins)],0) return CALCULATE ( DISTINCTCOUNT(Task[TaskID]) ,filter(TaskStatus,TaskStatus[TaskStatus] in {"In Progress","Not Started"}) ,FILTER(ALL(Task), _selected > Task[createddate]) )
I copied MinDate in new measure window and got error message.
Wild guess, date is a reserved word, try ‘date’ quoted
Tried 'Date', same error message.
this is what you need
taskBegDay3 = VAR _selected = SELECTEDVALUE('Date'[Date (bins)],0) return CALCULATE ( DISTINCTCOUNT(Task[TaskID]) ,filter(TaskStatus,TaskStatus[TaskStatus] in {"In Progress","Not Started"}) ,FILTER(ALL(Task), _selected > Task[createddate]) )Nickgastaldi, it works. Thanks so much. Try to understand selectedvalue you are using.