Forum Discussion

mihaita_baro's avatar
mihaita_baro
Helper II
3 years ago

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...
Need Help
Show and Tell
Tips and Tricks
Mahesh0016's avatar
Mahesh0016
Super User
3 years ago
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's avatar
    mihaita_baro
    Helper II
    3 years ago

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