Forum Discussion
Need Help - Average a new measure
Super UserHi Anonymous
You can not add a measure to the card and change the aggregation to the Average. You need to write a new measure and use that in that card.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos 🙏!!
Thanks Vahid.
So I need to write a new measure that averages the values I want to put in the card? How would that look based on the formular in the screenshot I sent??
- VahidDM
Hi Anonymous
It's hard to say with those screenshots 😅
Can you share a sample of your data in a table format? (Use those links edhans mentioned in his reply below to get your answer faster)
Appreciate your Kudos ✌️!!
Hi Vahid,
Attached is a sample of the data. https://www.dropbox.com/scl/fi/j4y73gb524rt0kahp04n9/Book1.xlsx?dl=0&rlkey=hshwg4e8kdk9awlb1hz81yit1
The measure forumla is in the screenshot above with the oputputs in the table. so for exampl Game TD% presneted in the table is correct. I then want the card to read an average value of Game TD % for all the participants in that table for that day and that group. At the moment the card is reading as a total % so all the values for Game TD% together.
- VahidDM
Is there a relationship between tables? Can you share a sample of your power bi desktop file here?
Appreciate your Kudos!!