topic Re: Dax Measure with multiple filters and a global NOT condition in DAX Commands and Tips

Dax Measure with multiple filters and a global NOT condition

Anonymous — Mon, 10 Jul 2023 16:07:04 GMT

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...

Re: Dax Measure with multiple filters and a global NOT condition

WinterMist — Mon, 10 Jul 2023 16:25:28 GMT

Anonymous

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"))

)

Re: Dax Measure with multiple filters and a global NOT condition

Anonymous — Tue, 11 Jul 2023 07:32:02 GMT

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]

Re: Dax Measure with multiple filters and a global NOT condition

WinterMist — Tue, 11 Jul 2023 13:53:49 GMT

Anonymous

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

Re: Dax Measure with multiple filters and a global NOT condition

Anonymous — Tue, 11 Jul 2023 14:04:08 GMT

Hi Nahan,

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

thanks

Sam

Re: Dax Measure with multiple filters and a global NOT condition

WinterMist — Tue, 11 Jul 2023 14:36:27 GMT

Anonymous

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

Hopefully this is helpful to you.

Nathan

Re: Dax Measure with multiple filters and a global NOT condition

Anonymous — Tue, 11 Jul 2023 14:47:40 GMT

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

Re: Dax Measure with multiple filters and a global NOT condition

WinterMist — Tue, 11 Jul 2023 14:54:15 GMT

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!