cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rdantasss Frequent Visitor
Frequent Visitor

DAX Average with filter

Hi!

 

I want to make a new measure with an Average and a filter.

 

There's my data:

 

MEDIA POWERBI.png

 

On Powerbi, I want a measure of an average from year 2018 and other measure with year 2019.

 

How can I do this on PB ?!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: DAX Average with filter

Hi @rdantasss 

Try creating these two measures and place them, for instance, in a card visual. Table1 is the table you show:

 

AVG_2018 =
CALCULATE ( AVERAGE ( Table1[Quant] ), Table1[Year] = 2018 )
AVG_2019 =
CALCULATE ( AVERAGE ( Table1[Quant] ), Table1[Year] = 2019 )

  

Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here.

3 REPLIES 3
Super User
Super User

Re: DAX Average with filter

Hi @rdantasss 

Try creating these two measures and place them, for instance, in a card visual. Table1 is the table you show:

 

AVG_2018 =
CALCULATE ( AVERAGE ( Table1[Quant] ), Table1[Year] = 2018 )
AVG_2019 =
CALCULATE ( AVERAGE ( Table1[Quant] ), Table1[Year] = 2019 )

  

Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here.

rdantasss Frequent Visitor
Frequent Visitor

Re: DAX Average with filter

Thanks for your help and your insight about the sample data!

Super User
Super User

Re: DAX Average with filter

@rdantasss 

A simpler, more scalable, way of doing it:

 

1. Place Table1[Year] in the rows of a visual matrix

2. Create the following measure and place it in the matrix visual: 

Answer_Perc =
AVERAGE( Table1[Quant])

With that you'll have one measure that can be used for all years, with the result for each on the rows of the matrix visual   

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 276 members 2,856 guests
Please welcome our newest community members: