Filter only some columns of Data

[Anonymous]

Hello I am trying to create a report to track Employee's absent time across business areas. I have a table that looks like this;

Empl./Appl.Name	Date	Number	Org. Unit	Business Area
Alan	2020-12-21	8	50541520	Training
Alan	2020-12-22	8	50541520	Training
Alan	2020-12-23	8	50541520	Training
Francis	2021-07-12	0,23	50644332	IT
Francis	2021-10-13	8	50644332	IT
Jenn	2021-02-19	8	10013520	HR
Jenn	2021-04-19	4,7	10013520	HR
Jenn	2021-07-20	8	50716112	Quality

I would like to inset a Filter for Business Area, but in a way that will not filter total absent time for the Employee. For example If I have the Filter selected for Quality, I would See Jenn's total absent time as 20.7 instead of 8. (and I know I would Also see Jenn when I filter for HR). I have tried some things with Edit Interactions on visualizations but haven't had any luck so far. 

I have linked a Sample File 

Thanks!

[v-shex-msft]

Hi @Anonymous ,

Did PoojaShri 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

@Anonymous 
Create a calculated column as follows:

Absent Hours = CALCULATE(SUM('Table'[ Number]),

FILTER('Table', 'Table'[Empl./Appl.Name]=EARLIER('Table'[Empl./Appl.Name])))

Did I answer your question?
Please mark the solution as Accepted!