cancel
Showing results for
Did you mean:
New Member

## 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!

9 REPLIES 9
Super User

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

New Member

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.

New Member

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

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

New Member

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!

Super User

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

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

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

#### Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors