cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## 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
Frequent Visitor

@vanessafvg I figured it out!

Thanks for the help!

10 REPLIES 10
Super User

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Anonymous
Not applicable

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
Not applicable

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 User

@Anonymous  how are you calculating that measure?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Anonymous
Not applicable

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 User

please see attached if this is what you looking for?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Frequent Visitor

@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

@vanessafvg I figured it out!

Thanks for the help!

Helper V

Super User

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors