How do i get the average of a measure with DAX?

[Anonymous]

I need to have the average of a measure but how can i do this?

In the image u can see what output i would like to achieve.

https://imgur.com/a/eISuOwj

[vanessafvg]

@Anonymous  can you paste the data in here rather than a pic?

[Anonymous]

Hey what data u want me to give you? I would like to have the average of a measure but i can't seem to find a way to achieve this.

[Anonymous]

For example i got these columns

Budget	Sales	% Actuals
1.971.793	132.412	6.7%
3.397.666	234.819	6.9%
1.152.450	87.791	7.6%
1.323.337	154.675	11.7%
460.306	55.207	12.0%

The column "% Actuals" is a measure and i would like to have to average of this.

@vanessafvg 

[vanessafvg]

@Anonymous  how are you calculating that measure?  

[Anonymous]

The calculation happens through a few measures ill post them below

This is the measure i want to get an average from:

△ % Budget Actuals = [△ Budget Actuals] / [Budget]

----------

△ Budget Actuals = [Sales] - [Budget]

Sales = Sum(Sales[Sales Amount])

Budget = SUM(Sales[Budget])

@vanessafvg 

[vanessafvg]

please see attached if this is what you looking for?

[VitoMas]

@vanessafvg First of all thanks for the effort you are putting in! But this isnt quite what i need

I need something like this

Budget	Sales	% Actuals
1.971.793	132.412	6.7%
3.397.666	234.819	6.9%
1.152.450	87.791	7.6%
1.323.337	154.675	11.7%
460.306	55.207	12.0%

The average of the column % Actuals would be 8,98%. I want to make something like this with the average

Budget	Sales	%   Actuals	Average
1.971.793	132.412	6.7%	8,98%
3.397.666	234.819	6.9%	8,98%
1.152.450	87.791	7.6%	8,98%
1.323.337	154.675	11.7%	8,98%
460.306	55.207	12.0%	8,98%

[VitoMas · Accepted solution]

@vanessafvg I figured it out! 

Thanks for the help!

[cathoms]

Can you please post your solution for the benefit of others?

[vanessafvg]

hi @Anonymous  what i mean is just paste the data in text, not the picture, otherwise i can't copy it out, so i can take the data and create the measure in power bi  for you and paste it back