Where to include the ALL function in my measure

[Anonymous]

Hi,

I have the following measure:

Measure =

VAR counting= ADDCOLUMNS('Tabel2',"Counthowmanytimes",COUNTROWS(FILTER(Combined,FIND('Tabel2'[Issue Source],TABLE1[Issue Source],,0)>0)))

RETURN

SUMX(counting,[Counthowmanytimes])

This measure (if I am correct) counts how many times the [Issue Source] column from Table 2 matches the [Issue Source] from Table 1.

Table 1 and 2 are disconnected tables (and should stay that way).

The [Issue source] column from table 2 has parts of the text of the [Issue source] column from table 1.

Now I want to include an ALL function from a column because I want to exclude a slicer from Table 1 on the visual page.

Can you please help me, where do I include this ALL function?  
I have tried to include it directly after FILTER(ALL) => but then I cannot use the tablename directly afterwards anymore.

Thank you for your advice on this measure.

[v-yalanwu-msft]

Hi, @Anonymous ;

Thanks for your sharing! Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

For future references: I solved it differently eventually.
First I connected the tables in the datamodel on [Issue Source]. Then I used the following measure: 

CALCULATE(COUNT(Table1[ID]), ALL(Table1[Priority]), FIND(Table2[Issue Source],Table1[Issue Source],,0))

NB the COUNT(Table1[ID] was not mentioned in the post above, but could as well have been another column. The above measure solved the inclusion of the ALL function nicely.

[Greg_Deckler]

@Anonymous Maybe:

VAR counting= ADDCOLUMNS('Tabel2',"Counthowmanytimes",COUNTROWS(FILTER(Combined,FIND('Tabel2'[Issue Source],ALL(TABLE1[Issue Source]),,0)>0)))

It's hard to know for sure without sample data to test with