Hello people.
I want to calculate the average of a variable depending on how many multiselects I do on my Slicer.
For example I select on my slicer two rows:
2021-04
2021-05
Table for those two selections:
Date Percentage
2021-04 97
2021-05 99
No I want a card which doesnt add 97 and 99 (currently showing 196) but take the average of both showing 98.
How can I realize this with a measure which I can simply assign to the card?
Obviously this should work for all amounts of selections, etc.
Thanks in advance 🙂
Solved! Go to Solution.
@lynnsop , New measure
If percent is a measure
averagex(Values(Date[Date]), [percent])
If this a column
averagex(Values(Date[Date]), calculate(average(Table[percent])))
@lynnsop , New measure
If percent is a measure
averagex(Values(Date[Date]), [percent])
If this a column
averagex(Values(Date[Date]), calculate(average(Table[percent])))
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
348 | |
98 | |
62 | |
49 | |
49 |
User | Count |
---|---|
333 | |
119 | |
79 | |
68 | |
62 |