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...
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.