Forum Discussion

krisjean's avatar
krisjean
Regular Visitor
2 years ago

AVERAGE

i have  a student table  and each row has the data of rollno,name,  and marks of ,exam1,exam,2,exam3 and so on.  i want to take the average  per  students  like XL in power bi . when i tried it gives sum only.

 

id   name              50      50      50     53     43    78   and average  at end end  e.g.  avg mark  54

Tips and Tricks

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    Hi, 

    I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

    I hope the below can provide some ideas on how to create a solution for your datamodel.

     

     

     

     

     

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi krisjean 
    Please try to create this measure. it definitely solve your issue.

    I have taken you example. and created the solution.

    I hope my post helps you. Please give kudos and accept as a solution!
    Thanks