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

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

@vanessafvg I figured it out! 

 

Thanks for the help!

View solution in original post

9 REPLIES 9
vanessafvg Super Contributor
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?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
vitoow Frequent Visitor
Frequent Visitor

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

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.

 

 

vanessafvg Super Contributor
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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
vitoow Frequent Visitor
Frequent Visitor

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

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 

vanessafvg Super Contributor
Super Contributor

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

@vitoow  how are you calculating that measure?  


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
vitoow Frequent Visitor
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])
 
 
 
vanessafvg Super Contributor
Super Contributor

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

please see attached if this is what you looking for?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
VitoMas Frequent Visitor
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

 

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

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

@vanessafvg I figured it out! 

 

Thanks for the help!

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)