I am trying to graph an average for a column entitled TalkTimeAvg__Column vs CallMonth as a line graph, and it is graphing an overall total instead of an average.
Here is the formula for the TalkTimeAvg__Column
The issue is that the Y-Axis should be showing an average between 1 and 10 for all of the employees for each month. Instead it is showing a sum.
Does anyone know how to fix this?
Solved! Go to Solution.
Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.
I think you are getting confused between calculated column and measure. Share the link from where i can download your PBI file.
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!
Watch Session 22 Ted's Dev Camp along with past sessions!
Click here to read more about the May 2022 updates!