Ignore slicer filter and include hours thats not in same project

[Anonymous]

Hi,

I have a question that I'm not sure is possible, but trying anyways hoping someone has a clever workaround for this.

I have a table where i use slicers to get a spesific date and a Responsible_id. This filters that below table, which in theory is correct, however this Empl_id also worked 4 hours on Referencekey 4292 that same day. This is not showing when I use slicer for Responsible_id = 100.

I have included a second table where it is showing those 4 hours, but i have made that table ignore the slicer and added a filter for Empl_id = 100.

I would like my first table to show all reference key where selected Responsible_id is selected as well as where this id is not responsible but would show up in Empl_id. 

My measure for Total Hours is:

Total Hours = CALCULATE([All Hours],

FILTER(Table1,Table1[Empl_id] = SELECTEDVALUE(Table2[Responsible_id])))

Date	Number	Refreencekey	Responsible_id	Total Hours	Empl_id	All Hours
3/24/2020	1000	4293	100		124	8
3/24/2020	1000	4293	100	12	100	12
3/24/2020	1200	4293	100		111	4
Total				12		24

Date	Number	Refreencekey	Responsible_id	Total Hours Responsible	Empl_id	All Hours
3/24/2020	1000	4292	124		100	4
3/24/2020	1000	4293	166	12	100	12
Total				12		16

Thanks!

[v-easonf-msft]

Hi , @Anonymous 

In the formula you mentioned ,are table 1 and table 2  the same table? Is  "All hours"  also  a measure?

Is this your excepted  result,when you use slicer for Responsible_id = 100?

Date	Number	Refreencekey	Responsible_id	Total Hours	Empl_id	All Hours
3/24/2020	1000	4293	100		124	8
3/24/2020	1000	4293	100	12	100	12
3/24/2020	1200	4293	100		111	4
3/24/2020	1000	4292	124		100	4
Total				12		28

Best Regards,
Community Support Team _ Eason

[Greg_Deckler]

What does your original source data look like? And what is the formula for All Hours? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[parry2k]

@Anonymous is this what you are looking for if filter by responsible_id 100

if yes then here is the measure:

Emp Hours = 
VAR __empList = VALUES ( Emp[Empl_id] )
RETURN
CALCULATE ( 
    SUM ( Emp[All Hours] ), 
    ALL ( Emp[Responsible_id] ),  
    __empList 
)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

Awesome, that did made it much better, not exactly what I wanted as I needed a few more adjustments (issues I didn't notice until after I asked the question), but definitely on the right track! Thanks a lot.