Please explain AverageX to me and filter content

[rpinxt]

I will attache a link with a sample file to make everything more clear.

Have this simple table visual:

Period, a measure being DPMO and a quick measure that I based on this to get the average DPMO.

However as you can see the average is the same in all lines which makes no sense.

The period is from 10-2022 to 10-2023 and all these lines should show the total of the period being 1069.

For sure it has to do with the KEEPFILTERS option in the quickmeasure I guess.

But I cannot seem to change the formula to get 1069 everywhere.

The link to this sample file:

https://drive.google.com/file/d/1kFqaEQ0O2nE7hMAAFHbs4rUB0dsj8JEl/view?usp=drive_link

[rpinxt · Accepted solution]

I got the reply via another post.

This was the solution:

DPMO_avg = IF([DPMO]>=0 && NOT ISBLANK([DPMO]),CALCULATE(AVERAGEX(VALUES('dimDate'[Period]),[DPMO]),ALLSELECTED()))

[Anonymous]

Hi @rpinxt ,

I can't access your pbix file for privacy reasons. Please have a try.

measure =
AVERAGEX ( ALL ( table ), Table[DPMO] )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rpinxt]

Thanks @Anonymous but this also only gives me the correct number in the total and not the total number for every month/period.

Saw that my link was indeed not "open".

Now you should be able to access the link.

Sistuation should be clearer when you see the data.

[rpinxt]

Ok....probably harder than I thought.

Figured I would not be to hard to show a total on every line.

[rpinxt]

Does not need to be with given meausure!

By all means if you guys know a better way in my added sample file please let me know.

So have 1069 on every line of the periods in scope.