DAX Measure Help - Average

[rbalza]

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 the client name with zero or an empty value on the calculation 2.) Dividing the [Client Name] to [Total Amount]

For example on the April 2021 column, there were clients that have an empty value in which we're going to be excluded from the calculation

[rbalza · Accepted solution]

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]))
)