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

 

 

 

 

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

     

1 Reply

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