Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello everyone,
I don't know if it is possible but I would like to add a column to this matrix where the average of the 3 averages is calculated.
To be more precise, I would like a column that calculates:
Total = (2.85 + 3.77 + 2.66) / 3
I would like to calculate it by the values already in the table because with those I can filter by date.
Thank you
Hello @MatildeBecherel ,
You need first to create the average in a measure.
after that, you create a measure that sums them all and then use the divide function to divide them by 3.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
| User | Count |
|---|---|
| 55 | |
| 37 | |
| 23 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 58 | |
| 39 | |
| 21 | |
| 21 |