topic Re: Need Help - Average a new measure in DAX Commands and Tips

Need Help - Average a new measure

Anonymous — Mon, 20 Sep 2021 18:48:47 GMT

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.

Re: Need Help - Average a new measure

edhans — Tue, 21 Sep 2021 00:47:59 GMT

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.

Re: Need Help - Average a new measure

VahidDM — Tue, 21 Sep 2021 03:58:41 GMT

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

Re: Need Help - Average a new measure

Anonymous — Tue, 21 Sep 2021 07:10:32 GMT

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

Re: Need Help - Average a new measure

VahidDM — Tue, 21 Sep 2021 07:43:23 GMT

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

Re: Need Help - Average a new measure

Anonymous — Tue, 21 Sep 2021 10:24:17 GMT

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.

Re: Need Help - Average a new measure

VahidDM — Tue, 21 Sep 2021 11:07:21 GMT

Is there a relationship between tables? Can you share a sample of your power bi desktop file here?

Appreciate your Kudos!!

Re: Need Help - Average a new measure

Anonymous — Tue, 21 Sep 2021 15:05:32 GMT

Have you got a private email??