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

Hi vanessafvg ,

thanks for quick reply.

 

Sorry for the screenshot. Is it sufficient to copy+paste here the Excel data?

Please tell in case an upload is needed (and where to upload best):

 

Activities    
date territoryproductaccountchannel
1.1.21TerrAProdAAccAF2F
1.14.21TerrAProdBAccBEmail
1.14.21TerrAProdBAccBF2F
1.26.21TerrBProdAAccAF2F
2.2.21TerrAProdAAccAF2F
2.3.21TerrAProdBAccBEmail
     
     
     
Example:    
     
     
TerritoryTerrA   
Year Month2021 Jan   
     
Field Days: 2   
Activities:3   
     
     
     
Activities per Field Day   
 F2FEmail  
 10,5  
     
  • vanessafvg's avatar
    vanessafvg
    Community Champion
    4 years ago

    see attached but its incomplete  and not sure what other requirements it needs.

     

    What is the definition of the values per day under email 0,5?  

     

    see file attached to start.