Getting Average of Measure

[Anonymous]

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?

[rajulshah]

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

[Anonymous]

@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"

)

[rajulshah]

@Anonymous,

So, what I understand is you want to average the value among female and male, right?

[Anonymous]

@rajulshah  Yes, but I have the male and female in measures. When I put them on the line chart, I can't select average. I could only do that if they were columns, but in this case they have to be measures

[rajulshah]

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.

[Anonymous]

Thanks rajulshah

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

[rajulshah]

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

[Anonymous]

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]

@Anonymous,

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

[amitchandak]

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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601