Forum Discussion

JulietZhu's avatar
JulietZhu
Helper IV
7 years ago
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(*...
Need Help
  • Nickgastaldi's avatar
    Nickgastaldi
    7 years ago

    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])
                          
              )

     

JulietZhu's avatar
JulietZhu
Helper IV
7 years ago

Nickgastaldi,  I tryied your DAX and remove all, but it still returns blank.

 

I need count all the tasks created before 1st of each month, which is minDate of each month.  My report is monthly and slice has to be month. For example, if Aug 2018 is choose, I need calculatued all the task created before Aug 1st 2018.  Please help. Thanks

 

JulietZhu's avatar
JulietZhu
Helper IV
7 years ago

Anybody help? Wating for answer to continute my project. Thanks