Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate average by group ignoring certain filter

Hello,   my data looks like the following   Date                 Emloyee      Group        Task         Duration 2020-01-01       A                 1                aa            2 2020-01-01  ...
Need Help
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

try this measure

Measure = 
CALCULATE(
    AVERAGE( 'Table'[Duration] ),
    ALLEXCEPT( 'Table', 'Table'[Task], 'Table'[Emloyee] ),
    ALLSELECTED( 'Table'[Emloyee] )
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn