Need Help - Average a new measure

[Anonymous]

 

 

Hi All,

I am trying to average a new measure in a card but struggling. The card is only reading a total amount and giving no option to go to an average. Attached are some photos.

Any help is much appreciated. 

[VahidDM]

Hi @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 🙏!!

[Anonymous]

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 ✌️!!

[Anonymous]

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!!

[Anonymous]

Have you got a private email??

[edhans]

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.