Forum Discussion

rbalza's avatar
rbalza
Helper III
5 years ago
Solved

DAX Measure Help - Average

Hi Everyone,   I have a matrix table with Rows [Client Name], Column [Month & Year] and Values [Amount]. Would like to get the average of the amount in the column with the context of 1.) Removing t...
DAX Measures
  • rbalza's avatar
    rbalza
    5 years ago

    Had to use the quick measure that solves my query 🙂 

    Average Revenue per Client =
AVERAGEX(
    KEEPFILTERS(VALUES('Invoices'[XPM Client Name])),
    CALCULATE(SUM('Invoices'[Amount]))
)

     

rbalza's avatar
rbalza
Helper III
5 years ago

Had to use the quick measure that solves my query 🙂 

Average Revenue per Client =
AVERAGEX(
    KEEPFILTERS(VALUES('Invoices'[XPM Client Name])),
    CALCULATE(SUM('Invoices'[Amount]))
)