Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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]))
)
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]))
)
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |