powerbi - Edit interaction within all the visualisation in Power BI

Question

I have data and I want to calculate the average training hrs per employee and wanted to show it in card visualisation. But the problem is when I click on any graph suppose a donut chart showing male and female, when u click on male then all the graphs will change instantly and show data according to male. But that card where I have taken training hrs/empl in values which shows 19.2 (for eg) that card doesn't change accordingly which is supposed to change.

What I have tried -

Created a new column

TR_HRS_PR_EMP =
CALCULATE (
    DIVIDE (
        SUM ( 'TRAINING_DATA'[Training Hours] ),
        DISTINCTCOUNT ( 'TRAINING_DATA'[Employee Code] )
    ),
    FILTER (
        'TRAINING_DATA',
        'TRAINING_DATA'[Source] = "2020-21"
            || 'TRAINING_DATA'[Source] = "2019-20"
            || 'TRAINING_DATA'[Source] = "2018-19"
    )
)

My data-

Employee Code	Training Hours	Source
012	5	2019-20
665	2	2018-19
8875	2	2018-19
980	2	2018-19
1132	7	2020-21
6221	2	2018-19

question from:https://stackoverflow.com/questions/65904152/edit-interaction-within-all-the-visualisation-in-power-bi

Answer 1

Waitting for answers