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.

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