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

 

Please help

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

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