Forum Discussion

tbones's avatar
tbones
Helper II
4 years ago
Solved

Summarize + All(single Column)?

Hello all,   I have among others one table "Activities" with activities in different territories (see in attached screenshot).   Example is that territoy TerrA got 3 activities in January 21 over...
Need Help
  • vanessafvg's avatar
    vanessafvg
    4 years ago

    this should work if there are no other considerations

     

    Activities Per day =
    var NoofDays = CALCULATE(DISTINCTCOUNT(Activities[date ]),REMOVEFILTERS(Activities[channel]))
    return DIVIDE(Activities[Activities], noofdays, 0)

     

    see file attached
vanessafvg's avatar
vanessafvg
Community Champion
4 years ago

please provide data in text format.