Forum Discussion
Calculate an average value from a filtered column
- 4 years ago
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
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 😄