Filter with All

[Anonymous]

Hi 

I need to create a DAX query that will filter based on a column value, unless the user enters all, which will effectivly make the filter not filter at all

[Anonymous · Accepted solution]

I worked this out another way, using CONCATENATEX, with a distinct to just add all distinct values

[Anonymous]

The value would be put into an SSRS report (paginated) parameter, so it would be querying a Power BI dataset

[edhans]

Where would the user enter "all" in a DAX query?

Or are you talking a slicer? If that, then your DAX just does the calc. The slicer will automatically filter based on any specific selection or no selection.