Forum Discussion
nmck86
Post Patron
Post Patronavg 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...
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
Super User
Super UserHi,
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.
nmck86Post Patron
Post PatronCan you share the file also?
- Ashish_Mathur
- nmck86
Thank you again for saving the day!!!! I appreciate your help!!! AGAIN!
- Ashish_Mathur
You are welcome.