Forum Discussion
Average occurrence
Hi guys, I am trying to calculate average sessions of High Intensity: 1st Step and Low Intensity: 1st Step, but i have no ideea how to do that, is either my brain thinking about Christmas Holiday...
Average occurrence = CALCULATE(AVERAGE('Table'[revsessions type]),ALLEXCEPT('Table','Table'[revsupportcategory]))
mihaita_baro if this post no helps so Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
hi Mahesh0016
Please see the data on this link https://we.tl/t-WH6ylSQ2gS
I have tried your measure but nothing comes up, i get error because revSession type is a string and average doesnt work with string
Avg high 1 step = CALCULATE(AVERAGE('All Sessions FTB'[revSession type]),ALLEXCEPT('All Sessions FTB','All Sessions FTB'[revsupportcategory]))