Forum Discussion
Getting Average of Measure
On one of my line charts, I have measures which contain percentages for all females for a number of groups.
When I put the measure on a line graph, it shows the sum of all percentages = 500%, however I want to get the average = 92%. I can do this with normal column variables, but it doesn't allow me to do it with measure.
Do you know how I can do this with measures?
10 Replies
I doubt the measure calculation has some issues.
Also, refer
https://geekdecoders.blogspot.com/2019/02/how-to-insert-average-line-in-power-bi.html
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Hello Anonymous,
You can use the following DAX:
Average Value = AVERAGEX(SUMMARIZE(Table,Table[Group],"AverageV",[Average Measure]),[AverageV])
Please let me know if this didn't help and provide more details so that I can help you with accurate DAX function.- rajulshah Thanks for replying. How would I apply that DAX function to my current measure? This is the code for it:MALE PRESENT NATIONAL =CALCULATE([Present Percent National],'All Years Characteristics'[Characteristics] = "MALE")
Anonymous,
So, what I understand is you want to average the value among female and male, right?
