Forum Discussion

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


Any help is much appreciated. 

 

average of a measure
DAX
new measure

7 Replies

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    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.

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 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
        Super 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 ✌️!!