DAX Measure Help - Average

rbalza — Thu, 10 Jun 2021 02:21:41 GMT

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

Re: DAX Measure Help - Average

rbalza — Thu, 10 Jun 2021 03:06:12 GMT

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

topic DAX Measure Help - Average in DAX Commands and Tips

DAX Measure Help - Average

Re: DAX Measure Help - Average