Forum Discussion
Summarize + All(single Column)?
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
Hi vanessafvg ,
thanks for the reply!
I had also the activities and days already, but struggeling for the combination with channels.
Sorry for inaccurate explanation. I try to give more infos.
Activities per day and channel is what I need.
For F2F it would be this calculation for the given example (January 21, TerrA):
- 2 F2F activities
- 2 days with activities
- >> 2 F2F activities per total 2 days with activities = 2/2 = 1
- >> TerrA is having one F2F activity per active day
For email it would be this calculation for the given example:
- 1 email activity
- 2 days with activities
- >> 1 email activity per total 2 days with activities = 1/2 = 0,5
- >> TerrA is writing 0,5 emails per active day
The target is this one - this is what I need:
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 attachedThank you.
the attached PBIX looks good and it seems to work well.
After creating the measure in my modell using copy-paste strangely it didn't work.
it must be the part:
var NoofDays = CALCULATE(DISTINCTCOUNT(Activities[date ]),REMOVEFILTERS(Activities[channel]))
-> when I test this in separate measure it returns me for each channel the filtered (by channel) value like here:
Channel Noofday F2F 1 Email 1 Total 2 I would expect this:
Channel Noofday F2F 2 Email 2 Total 2 What could be the reason?
it would be hard to tell without looking at your pbix, are you able to share it?