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
tbones's avatar
tbones
Helper II
4 years ago

I found the reason.

I have a calculated column to sort the "channels" column using relationship to another channel sorting table.

after adding REMOVEFILTERS also to this "channel_sort" column it worked.

Tricky...

 

Thank you any way!!