Forum Discussion

ukeasyproj's avatar
ukeasyproj
Icon for Helper II rankHelper 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])