Forum Discussion

ukeasyproj's avatar
ukeasyproj
Helper II
9 years ago
Solved

looking for a workaround for using countrows in a calculated column in DQ mode

Some background info:   What I am trying to do is, for a given taskid+userid, I am trying to calculate the [# of days]   [# of days] will then be used to calculate [estimated hours per day] which...
Need Help
  • MattAllington's avatar
    MattAllington
    9 years ago

    Hi

     

    I have been thinking - and I wanted to give you a different solution in case you prefer it.  This solution assumes 1 flat table exactly as you explained in the OP.  If you write these measures I think it will do what you want.

     

     

    Total Task Hours = max(Table[estimated hours])

    Count of Entry Date for Task = CALCULATE(DISTINCTCOUNT(Table[entry date]),all(Table),VALUES(Table[task id]))

    Daily Hours for Task = sumx(SUMMARIZE(Table,Table[entry date],Table[task id]),[Total Task Hours]/[Count of Entry Date for Task])

MattAllington's avatar
MattAllington
Community Champion
9 years ago

Try this

 
Count of Entry Date for Task = CALCULATE(DISTINCTCOUNT(Table[entry date]),allexcept(Table,table[entry date]))

ukeasyproj's avatar
ukeasyproj
Helper II
9 years ago

MattAllington

 

Thanks, it works, I just have one question, going back to the old measure:

 

Count of Entry Date for Task = CALCULATE(DISTINCTCOUNT(GetPlannedHoursForPeriodOfDaysFunc[DateEntry]),all(GetPlannedHoursForPeriodOfDaysFunc),VALUES(GetPlannedHoursForPeriodOfDaysFunc[TaskID]), VALUES (GetPlannedHoursForPeriodOfDaysFunc[UserID]))

 

What is the values function doing within the calculate, I can't seem to wrap my brain around it