topic Re: Filter SSAS Dax Query based on List of Values in DAX Commands and Tips

Filter SSAS Dax Query based on List of Values

ChrisFromOhio — Thu, 19 Sep 2024 12:41:29 GMT

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?

Re: Filter SSAS Dax Query based on List of Values

HarshSathwara19 — Thu, 19 Sep 2024 14:06:17 GMT

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

Re: Filter SSAS Dax Query based on List of Values

ChrisFromOhio — Fri, 20 Sep 2024 10:39:35 GMT

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.

Re: Filter SSAS Dax Query based on List of Values

HarshSathwara19 — Fri, 20 Sep 2024 11:56:03 GMT

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.