Slicer with Mulitple choice should act as AND Filter

[MrJoachim]

Hi, 

after trying and trying without success I would like to address my problem to you. 

I have a list of Tools. Each Tool can have an undefined amount of tags. (1-n relationship). 

With an slicer I want to filter the tools by tags. 

But: The result should be a list were ALL tags are in. If a tool don´t have ALL tags I´ve choosen with the slicer, then it should not be listed. 

The slicer per default filters the way that it shows all Tools whenever one of the tags are related to it. 

With help of other solved topics I already managed to get a List of the Tool IDs. The red marked in the picture is now missing. How can I get a list where only the IDs are listed which are in EACH line? In my example 11 and 44?

Here´s what I copied and modified from other similiar issues:

Distinct Number of Tool_ID = VAR mycount=COUNTROWS(VALUES(Filtered[Tag_ID]))
VAR temp=Filter(all(DigiToolbox_taged),DigiToolbox_taged[Tag_ID] In VALUES(Filtered[Tag_ID]))
VAR temp1=SUMMARIZE(temp,[Tool_ID],"Count",CountX(Filter(temp,[Tool_ID]=earlier([Tool_ID])),1))
VAR temp2=Filter(temp1,[Count]=mycount)
VAR temp3=SUMMARIZE(temp2,[Tool_ID])
VAR temp4=INTERSECT(VALUES(DigiToolbox_taged[Tool_ID]),temp3)
RETURN
If(HASONEFILTER(DigiToolbox_taged[Tag_ID]),COUNTROWS(temp4),COUNTROWS(temp1))

Check_Measure = If(SELECTEDVALUE(DigiToolbox_taged[Tag_ID]) IN VALUES(Filtered[Tag_ID]),1,0)

List of Tool_ID = VAR mycount=COUNTROWS(VALUES(Filtered[Tag_ID]))
VAR temp=Filter(all(DigiToolbox_taged),DigiToolbox_taged[Tag_ID] In VALUES(Filtered[Tag_ID]))
VAR temp1=SUMMARIZE(temp,[Tool_ID],"Count",CountX(Filter(temp,[Tool_ID]=earlier([Tool_ID])),1))
VAR temp2=Filter(temp1,[Count]=mycount)
VAR temp3=SUMMARIZE(temp2,[Tool_ID])
VAR temp4=INTERSECT(VALUES(DigiToolbox_taged[Tool_ID]),temp3)
RETURN
If(HASONEFILTER(DigiToolbox_taged[Tag_ID]),CONCATENATEX(temp4,[Tool_ID],", "),CONCATENATEX(temp1,[Tool_ID],", "))

It might be that my direction how to solve it is maybe totally wrong. 

In case of any other better solution for it please skip everything I´ve done so far 😉

Thanks in advance for your support!

Joachim

[MrJoachim]

Thanks Jirka, you made my day! 

[JirkaZ · Accepted solution]

Please see my test setup and the resulting measure:

Check Measure = 
VAR _ToolId = MAX(Tools[Tool ID])
VAR _SelectedTags = VALUES('Tags Slicer'[Tag])
VAR _SelectedTagsCount = COUNTROWS(_SelectedTags)
VAR _ToolIDsTable = SUMMARIZE(Tags,Tags[Tool ID], "Tags", COUNTROWS(FILTER(Tags, Tags[Tag] in _SelectedTags)))
VAR _IDsTable = FILTER(_ToolIDsTable, [Tags] = _SelectedTagsCount)


RETURN
IF(COUNTROWS(FILTER(_IDsTable, [Tool ID] = _ToolId)) > 0, 1, 0)