cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vitoow
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

@vanessafvg I figured it out! 

 

Thanks for the help!

View solution in original post

9 REPLIES 9
vanessafvg
Super User
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!




Screenshot_1.png

 

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.

 

 

For example i got these columns

 

BudgetSales% Actuals

1.971.793

132.4126.7%
3.397.666234.8196.9%
1.152.45087.7917.6%
1.323.337154.67511.7%
460.30655.20712.0%

 

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

@vanessafvg 

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




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

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!




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

I need something like this

 

BudgetSales% Actuals

1.971.793

132.4126.7%
3.397.666234.8196.9%
1.152.45087.7917.6%
1.323.337154.67511.7%
460.30655.20712.0%

 

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

 

BudgetSales%   ActualsAverage

1.971.793

132.4126.7%8,98%
3.397.666234.8196.9%8,98%
1.152.45087.7917.6%8,98%
1.323.337154.67511.7%8,98%
460.30655.20712.0%8,98%

@vanessafvg I figured it out! 

 

Thanks for the help!

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!




Helpful resources

Announcements
Carousel_PBI_Wave1

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.

Power BI Summit Carousel 2

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!

BizApps LATAM 2023

Business Application LATAM Summit 2023

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

Power Platform Bootcamp

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.