Forum Discussion

Hank_'s avatar
Hank_
Icon for Helper I rankHelper I
5 years ago
Solved

Sum of averages: why is my code wrong?

Hello everybody!   I have read some posts in the forum and I got my sum of averages working. But I noticed that when I am computing the sum of the averages, this computes also the zeros. My code is...
Need Help
  • Hank_'s avatar
    Hank_
    5 years ago

    I solved with NOT and ISBLANK, in this way:

    step duration avg measure = SUM(data[step duration]) / CALCULATE ( DISTINCTCOUNT ( data[# project], NOT( ISBLANK(data[step duration]].

    And then reused my group by measure.

    Thanks everybody for the hints! 🙂 

Hank_'s avatar
Hank_
Icon for Helper I rankHelper I
5 years ago

I solved with NOT and ISBLANK, in this way:

step duration avg measure = SUM(data[step duration]) / CALCULATE ( DISTINCTCOUNT ( data[# project], NOT( ISBLANK(data[step duration]].

And then reused my group by measure.

Thanks everybody for the hints! 🙂