Forum Discussion
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 ?!
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.
4 Replies
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
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
thanks
