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%, ho...
rajulshah
Resident Rockstar
Resident RockstarHello 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"
)