Filter SSAS Dax Query based on List of Values

[ChrisFromOhio]

Hello - like the title says, I have a SSAS Dax Query (Import) that I am trying to add a condition based on another list of values. These values are currently stored in an excel file. Right now, I'm importing all the rows of data (millions), then filtering the list down to the ~50k rows I need using the other query. Is it possible to use this list of values I need filtered on in the original query?

[HarshSathwara19]

Hi @ChrisFromOhio Yes, it's possible to filter the data in your query based on the list of values stored in your Excel file directly,

Follow the instructions in the ScreenCapture and let me know If it works for you or not

[ChrisFromOhio]

Thank you for the reply. How do I go about taking my list of values and converting that to a parameter, as this list can and will update from time to time.

[HarshSathwara19 · Accepted solution]

Apply List directly in your query, This works for me

let
    Source = YourOtherDataSource,
    FilteredRows = Table.SelectRows(Source, each List.Contains(MyList, [YourColumn]))
in
    FilteredRows

Best Regards,
HSathwara

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