Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks rajulshah

But that didn't return the average, it produced the same result as I had before

rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

Anonymous, can you please provide sample data and snapshot of what is showed in the table?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.
  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    6 years ago

    Anonymous,

     

    I guess I could help efficiently if there maybe any sample data available.