Dax Measure with multiple filters and a global NOT condition

[Samkar78]

Hi,

I'm trying to combine 2 filters on 2 differents tables with an overall NOT condition.

I exacly want the opposite of this measure :

CALCULATE([embauche turnover],

    Filter('Ref Motif entrée', 'Ref Motif entrée'[Code motif entrée]="10") ,

    Filter(Calendrier, Calendrier[Jour] = DATE("2023","01","01"))

    )

I imagine something like :

CALCULATE([embauche turnover], NOT(

    Filter('Ref Motif entrée', 'Ref Motif entrée'[Code motif entrée]="10") ,

    Filter(Calendrier, Calendrier[Jour] = DATE("2023","01","01")))

    )

But of course it doesn't work...

[Samkar78]

Thanks a lot !!!
As simple as that... when you know the solution  😁

[WinterMist]

LOL!  I know the feeling.

NOTE: Any time you can show a small dummy example of data along with a visual of the desired results, it always helps!

[WinterMist · Accepted solution]

@Samkar78 

In the dummy example provided, the following DAX returns the desired result:  67 - 15 = 52.

Hopefully this is helpful to you.

Nathan

[Samkar78]

Hi Nahan,

According to your dummy figures, I'm looking for all except the Yellow.
67-15 = 52

thanks

Sam

[WinterMist]

@Samkar78 

I created the following dummy table to hopefully understand your desired result better.

There are only 3 rows (yellow) where both conditions are met:

- Code = 10

- Date = 1/1/2023

There are 4 other rows (orange) where 1 of the 2 conditions is met.

For the remaining rows (no color), neither condition is met.

For my measure [Sales Amount], I'm just doing a SUM('Data'[Sales]).

For this new NOT condition measure, can you tell me what the expected result should be in this dummy scenario?

Should the expected result be:

- 52 (Total 67 - Yellow 15 = 52) OR...

- 27 (Total 67 - Yellow 15 - Orange 25 = 27) OR...

- Other?

Regards,

Nathan

[Samkar78]

Hi,
No it doesn't retreive the right result.

I want to exlude the data from that particular date AND this specific [Code motif entrée] 

The double filter with the <> condition exlude data from this Date and all the "10" [Code motif entrée] 

[WinterMist]

@Samkar78 

Would the following work?

CALCULATE([embauche turnover],

    Filter('Ref Motif entrée', 'Ref Motif entrée'[Code motif entrée] <> "10") ,

    Filter(Calendrier, Calendrier[Jour] <> DATE("2023","01","01"))

    )