topic Re: Filtering by values that aren't on my DB just yet in DAX Commands and Tips

Filtering by values that aren't on my DB just yet

Guillermo_LO — Sun, 16 Oct 2022 10:11:15 GMT

Hello! Through a Direct Query connection, I am trying to perform a DAX formula to filter by values that I know are not present in my DB just yet, but will be in the future; however, upon entering them into the formula and DQ not finding them, the visual doesn't work. Is there a way to get around this so I can set this filter?

Thanks in advance!

Re: Filtering by values that aren't on my DB just yet

Anonymous — Mon, 17 Oct 2022 01:36:44 GMT

HI Guillermo_LO,

What type of operations are you apply to your visuals? Can you please share some more detail about these to help us clarify and troubleshoot your scenario?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Filtering by values that aren't on my DB just yet

daXtreme — Wed, 19 Oct 2022 23:13:58 GMT

"... upon entering them into the formula and DQ not finding them, the visual doesn't work."

What does it mean "does not work"?

Re: Filtering by values that aren't on my DB just yet

Guillermo_LO — Sun, 23 Oct 2022 21:21:04 GMT

I'm sorry, I just realized the problem wasn't the DAX formula, but a date filter I had on which returned null values. Thank you for taking the time to help out nonetheless!