Forum Discussion

nmck86's avatar
nmck86
Post Patron
7 years ago
Solved

avg calculation

Below is the link to the pbix file that I need assistance with. I want to use a formula that will allow for the total score formula to show the avg if you select several months. So basically in the e...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    I selected Call failure in the slicer visual and create a seperate card visual.  In that card visual, i dragged this measure

     

    Measure=AVERAGEX(SUMMARIZE(VALUES('Calendar'[Month]),[Month],"ABCD",[RESULTS_SCORE]),[ABCD])

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

I selected Call failure in the slicer visual and create a seperate card visual.  In that card visual, i dragged this measure

 

Measure=AVERAGEX(SUMMARIZE(VALUES('Calendar'[Month]),[Month],"ABCD",[RESULTS_SCORE]),[ABCD])

 

Hope this helps.

 

  • nmck86's avatar
    nmck86
    Post Patron
    7 years ago

    Ashish did it work when you selected 3 or 4 months as well? I am going to test it out now but thought I would ask if you noticed if it worked. I noticed that for one or 2 months it works good but for other months being added it stopped shoing the true average.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      It works very well.  I selected May - Aug and the result is 39.00%.

  • nmck86's avatar
    nmck86
    Post Patron
    7 years ago

    Can you share the file also?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      Download the file from here.

      • nmck86's avatar
        nmck86
        Post Patron
        7 years ago

        Thank you again for saving the day!!!! I appreciate your help!!! AGAIN!