Forum Discussion

gco's avatar
gco
Resolver II
6 years ago
Solved

Average

Hi there,

 

I have a table with ProcessDate, Branch Name, and Balance by Branch.  And i am looking to get the average of the balance by branch by process date range.  Can you please tell me how to do it?

 

The process date is a range slicer.

Thank you

 

Glen

Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi gco ,

    Drop the The Branch Name on Columns and see measure below for value.

     

    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

     

     

    Average Balance = CALCULATE(AVERAGE(Branch[Balance]),ALLSELECTED(Branch[Date]))

3 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi gco ,

    Drop the The Branch Name on Columns and see measure below for value.

     

    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

     

     

    Average Balance = CALCULATE(AVERAGE(Branch[Balance]),ALLSELECTED(Branch[Date]))