Forum Discussion
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...
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
Thank 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 |
| 1 | |
| Total | 2 |
I would expect this:
| Channel | Noofday |
| F2F | 2 |
| 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?