Forum Discussion
User5231
Helper II
Helper IIUse a List as a table filter in DAX
Is it possible to essentially use a table/ list to filter a another table in dax? Right now I have a table that has material and a pegged material. Each material in the table can have multiple p...
Well I solved it. For anyone curious. Natural InnerJoin was the solution after all, just needed to fix the data lineage. Worked great after that.
User5231Helper II
Helper IIAlso, to simplify this further, I moved the naturalinnerjoin to the filter in table 1.
This is a one man thread but I could not find a solution to pass a list as a filter in dax anywhere. Everything directed you to power query or discretely listing out the filters. Hopefully someone can find some use here besides me.
User5231Helper II
Helper III discovered an even easier solution is to use the in Operator. If you have a list defined as a signle column variable, you can use the in operator to filter the table using the desired column list you have, whether is it explicit or gererated from a dax expression. Super handy.