Dax filter syntax

Hello Anonymous,

You may try this measure:

Customer Count =
VAR _Spain =
    DATE ( 2018, 2, 14 )
VAR _Canada =
    DATE ( 2018, 9, 24 )
VAR _France =
    DATE ( 2019, 7, 30 )
RETURN
    CALCULATE (
        COUNT ( dtTable[CustomerID] ),
        FILTER (
            dtTable,
            dtTable[Country] = "Spain"
                && dtTable[RegisterDate] >= _Spain
        )
    )
        + CALCULATE (
            COUNT ( dtTable[CustomerID] ),
            FILTER (
                dtTable,
                dtTable[Country] = "Canada"
                    && dtTable[RegisterDate] >= _Canada
            )
        )
        + CALCULATE (
            COUNT ( dtTable[CustomerID] ),
            FILTER (
                dtTable,
                dtTable[Country] = "France"
                    && dtTable[RegisterDate] >= _France
            )
        )

Then in the visual, you can add this as Filter = is not blank:

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn