Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?!
Solved! Go to Solution.
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.
thanks
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.
Thanks for your help and your insight about the sample data!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |