Filter table based on variable table column

Hi! I'm struggling to come up with a solution on how to filter a table based on values in a column of a variable/calculated table. So I was thinking of something like this: FILTER(Table,...

Need Help

Icey
4 years ago
Hi OskariNi ,

Try this:

Measure =

VAR Selected = ALLSELECTED(Table[Col], Table[Col2])

VAR AllRows = ALL(Table[Col], Table[Col2])

VAR ExcludeRows = EXCEPT ( AllRows, Selected )

VAR AffectedRows =CALCULATETABLE(SUMMARIZE(ExcludeRows,[Col]), KEEPFILTERS ( ExcludeRows))

var row_count = COUNTROWS(FILTER(Table, Table[Col] IN VALUES(AffectedRows))

return row_count

Or this:

Measure =

VAR Selected = ALLSELECTED(Table[Col], Table[Col2])

VAR AllRows = ALL(Table[Col], Table[Col2])

VAR ExcludeRows = EXCEPT ( AllRows, Selected )

VAR AffectedRows =CALCULATETABLE(ExcludeRows, KEEPFILTERS ( ExcludeRows))

VAR t_ = SUMMARIZE(ExcludeRows,[Col])

var row_count = COUNTROWS(FILTER(Table, Table[Col] IN t_)

return row_count

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Column1	Column2	Column3
A	1	6
B	2	7
B	3	8
C	4	9
C	5	10

Forum Discussion

Filter table based on variable table column

Related content

Dynamic Variable in Calculated Columns

Slicer for filtering several columns

Variable still filtered in visual where using REMOVEFILTERS

Creating a dynamic filtered table variable

Filter column only if variable is not blank