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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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