How can I apply multiple filters in a single filter?

[ChPetru]

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!

[v-yiruan-msft · Accepted solution]

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

[ChPetru]

Thank you!