cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

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

@vanessafvg I figured it out!

Thanks for the help!

9 REPLIES 9
Super Contributor

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

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

Proud a to be a Datanaut!
Frequent Visitor

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

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.

Super Contributor

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

hi @vitoow  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

Proud a to be a Datanaut!
Frequent Visitor

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

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.

Super Contributor

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

@vitoow  how are you calculating that measure?

Proud a to be a Datanaut!
Frequent Visitor

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

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])

Super Contributor

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

please see attached if this is what you looking for?

Proud a to be a Datanaut!
Frequent Visitor

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

@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%
Frequent Visitor

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

@vanessafvg I figured it out!

Thanks for the help!

Announcements