Average occurrence

[mihaita_baro]

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 or aint got a clue.

Please help

[Mahesh0016]

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.

[mihaita_baro]

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]))