cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BLM
Helper I
Helper I

AVERAGE

hii

i'm trying calculate the value average of a group of products. I attached a image with the column target:MEDIA.jpg

 

i don't know calculate this measure, anyone can help me, please.

 

thank

1 ACCEPTED SOLUTION

Hi @BLM

 

I have uploaded a simple PBIX file using your sample data set and it shows the measure working.  The only way it can come up with another figure is if there is other data in the model that we can't see.  Have a look at this and see what you think.

 

https://1drv.ms/u/s!AtDlC2rep7a-oi35BPacpxPxFVty

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

6 REPLIES 6
Ashish_Mathur
Super User III
Super User III

Hi,

 

Try this

 

=CALCULATE(AVERAGE([Unidades]),ALL(Data[PeriodoCalculo]))

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Phil_Seamark
Microsoft
Microsoft

HI @BLM

 

A calculation to find the average of the [Unidades] column per [CodArticulo] is as follows:  but this looks like what you have.  What is the number you are expecting?

 

media = 
    CALCULATE(
        AVERAGE('Table1'[Unidades]),
        FILTER(
            ALLSELECTED(Table1),
            'Table1'[CodArticulo] = MAX('Table1'[CodArticulo]
            )
        )
		)

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

sol1.jpg

 Yes, i'm expecting the average per CodArticulo, but your formula don't work. I attached image with the result.

The values that I expected are in the first image that I attached.

 

thank

Hi,

 

Share the link from where i can download your file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi @BLM

 

I have uploaded a simple PBIX file using your sample data set and it shows the measure working.  The only way it can come up with another figure is if there is other data in the model that we can't see.  Have a look at this and see what you think.

 

https://1drv.ms/u/s!AtDlC2rep7a-oi35BPacpxPxFVty

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

thank, it's work like I need.

 

thank you

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors