cancel
Showing results for
Did you mean:
Frequent Visitor

## DAX Average with filter

Hi!

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

There's my data:

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

## Re: DAX Average with filter

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

## Re: DAX Average with filter

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.

Frequent Visitor

Super User

## Re: DAX Average with filter

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

Announcements

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

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

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 276 members 2,856 guests
Recent signins: