Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.   Ho...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous 

    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.

AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous 

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Anonymous 

    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