Forum Discussion
Calculate an average value from a filtered column
You could do with the following:
Answered Calls = VAR _total = CALCULATE ( COUNTA ( 'PickupThePhone'[ID] ) ) VAR _filtered = CALCULATE ( AVERAGEX ( KEEPFILTERS ( VALUES ( 'PickupThePhone'[Date] ) ), COUNTA ( 'PickupThePhone'[ID] ) ), 'PickupThePhone'[UserName] = "Jim" ) RETURN DIVIDE ( _filtered, _total, 0 )Or by adding the filter directly to the visual. Your choice! 🙂
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Sorry, i don't understand what you mean, i'm not an advanced user at all.
I'm using a card visualisation that simply shows the result of the average calls a day :
for example, since January 1st, the card visualisation shows
56 calls/day
I just want to have another card showing the same average, but number of calls a day Jim picks up :
20 calls/day by Jim
You could do with the following:
Answered Calls =
VAR _total =
CALCULATE ( COUNTA ( 'PickupThePhone'[ID] ) )
VAR _filtered =
CALCULATE (
AVERAGEX (
KEEPFILTERS ( VALUES ( 'PickupThePhone'[Date] ) ),
COUNTA ( 'PickupThePhone'[ID] )
),
'PickupThePhone'[UserName] = "Jim"
)
RETURN
DIVIDE ( _filtered, _total, 0 )
Or by adding the filter directly to the visual. Your choice! 🙂
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
That works ! Thanks a bunch, thanks for your quick answer and solution 😄