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...
So, you can try creating 2 measures for Male and Female.
Male Average =
AVERAGEX (
FILTER (
SUMMARIZE (
'All Years Characteristics',
'All Years Characteristics'[Characteristics],
"AverageV", [Present Percent National]
),
'All Years Characteristics'[Characteristics] = "MALE"
),
[AverageV]
)Female Average =
AVERAGEX (
FILTER (
SUMMARIZE (
'All Years Characteristics',
'All Years Characteristics'[Characteristics],
"AverageV", [Present Percent National]
),
'All Years Characteristics'[Characteristics] = "FEMALE"
),
[AverageV]
)
Hope this helps.
Thanks rajulshah
But that didn't return the average, it produced the same result as I had before
Anonymous, can you please provide sample data and snapshot of what is showed in the table?
rajulshah If I made a calculated column, it would have this code:
MALE PRESENT NATIONAL =CALCULATE([Present Percent National],'All Years Characteristics'[Characteristics] = "MALE")And then I would select Average on the line chart instead of Sum. However, it needs to be a measure, so I used the same code but it wont let me select average.Anonymous,
I guess I could help efficiently if there maybe any sample data available.