topic How can I apply multiple filters in a single filter? in DAX Commands and Tips

How can I apply multiple filters in a single filter?

ChPetru — Mon, 16 May 2022 09:20:29 GMT

Hello,

I want to create a single filter that uses multiple dimensions to filter my data (master filter).

What is the best syntax for this?

e.g. Stage: Won and Pending && Specific Products && Date = Today().

Thank you!

Re: How can I apply multiple filters in a single filter?

Anonymous — Thu, 19 May 2022 02:12:55 GMT

Hi ChPetru ,

You can create a measure as below and apply a visual-level filter on your visual with the condition(Measure is 1).

Measure = IF ( MAX ( 'DimesionTable1'[Won and Pending] ) = TODAY () && MAX ( 'DimesionTable2'[Specific Products] ) = TODAY () && MAX ( 'DimesionTable3'[Date] ) = TODAY (), 1, 0 )

Best Regards

Re: How can I apply multiple filters in a single filter?

ChPetru — Thu, 19 May 2022 06:31:14 GMT

Thank you!