Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

All() not working properly

Hi,  I'm not sure if this is a known bug or issue, but I have seen some examples of it in the past on the forums but without much being resolved.  In short, I have a table for returns. I create...
Need Help
AlB's avatar
AlB
Community Champion
5 years ago

You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      5 years ago

      Hi,  Anonymous 

      I suspect the problem may be that the date field in your slicer and the owned field in your slicer are in the same table ( you need to keep/remove both filters in formula).

      As a workaround, you can add a  calendar table(build one-to-many relationship) for the date slicer creation：

       

      scheduled_at Table = CALENDAR(Min('Master Returns Table'[scheduled_at]),MAX('Master Returns Table'[scheduled_at]))

       

      Another solution is to disable the interaction of your Owned slicer with the table visual.

      Best Regards,
      Community Support Team _ Eason