Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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])))
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
131 | |
110 | |
64 | |
55 |