Getting the average of a measure column

DAX DAX Calculations
1

HI,

Ive seen Sams videos on this topic however i cant seem to get this to work.

I want to get the average of all these % in the column no matter what i do i always return the incorrect total.

Capture

I wrote the measure out as Sam suggested by doing a AverageX and Summarize values then average all the row results but i still get 40% when the correct result should be 92.5%

Average Main KPI FIX = 
AVERAGEX(
SUMMARIZE(VALUES('Head Count'[Employee Number] ), 
"toAverage", [Average Shift Completion %] ),
[Average Shift Completion %])

Also tried this

Average Main KPI FIX = 
AVERAGEX(
    SUMMARIZE(VALUES('SAP SQ00 Confirmations'[Employee Number] ), 
    "toAverage", [Average Shift Completion %] ),
    [toAverage])

If you could show me where im going wrong that would be magic

Dan

2

Hi @Krays23 ,

Make sure you add the PBIX file in your post. That way analyst’s can help a bit quicker.

Cheers

Adam

1 Like
3

Unfortunately I can’t due to company policies.

However i did manage to solve it myself.

    Total Shift Completion % = 
    AVERAGEX(
    SUMMARIZE( 'SAP SQ00 Confirmations', 'Head Count'[Employee Number],
    "toAverage", [Average Shift Completion %] ),
    [toAverage])
4

Well done Daniel!

5

Hi @Krays23. For future reference, you can easily sanitize a real dataset or create a sample dataset before posting a question to the forum; it really helps the forum members to visualize your issue and desired outcome. @BrianJ has a wonderful YouTube video on anonymizing data in a Power BI file: https://www.youtube.com/watch?v=VmWD7Ayw_NI
Greg