Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Need Help - Average a new measure

    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...
average of a measure
DAX
new measure
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      VahidDM
      Icon for Super User rankSuper User
      4 years ago

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

       

      Appreciate your Kudos!!

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Have you got a private email??