Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter with All

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's avatar
    Anonymous
    5 years ago

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

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

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.