Calculating an Average of a Measure

DAX DAX Calculations
1

I have created a measure that calculates the time lapsed between a customer purchase using DATEDIFF formula. I now want to write a measure that will return the TOTAL average of all customers. IN essence I want to know the overall average of all the averages.

2

you would want to use AveargeX to iterate over your customers table, with your average measure as the expression. Would be easier to show if you can upload your pbix file

3

it says the file is too big

4

How can i share the file. The AVGX formula did not work. it returns a value of zero.

5

Have you had a chance to review many of the videos and tutorials on AVERAGEX?

https://blog.enterprisedna.co/tag/averagex/

Using AVERAGEX is a very efficient way to complete any averaging in Power BI. Highly recommend understanding this function well.

See here for some initial theory on AVERAGEX

http://portal.enterprisedna.co/courses/mastering-dax-calculations/lectures/2399489

Here’s another good tutorial to review

Also for tips on adding a pbix file in the forum see here

https://forum.enterprisedna.co/t/does-your-support-question-have-everything-required-to-be-answered-effectively/3953

1 Like
7

Hi @nikahafiz

Please start a new topic as this posting is already solved. This way your question will be answer more quickly in the forum.

Also, please don’t forget to attached your power bi file and results you are expecting

Don’t forget to delete your posting here

thanks
Keith