Combine nested filtre

[Anonymous]

Hello everybody, i would like to filter on a table using a nested filter. here is my exemple :

i would like to remove the "ccube osgroup.name" = "Sans OS indiqué" and "type" <> 50 and keep all the rest.

i tried this in dax but it didn't work :

obs = CALCULATETABLE (

obsolescences, filter(obsolescences, and(obsolescences[ccube osgroup.name] = "Sans OS indiqué" , obsolescences[type] =50))

)

Thank you in advance for your answers,

[amitchandak · Accepted solution]

@Anonymous , Try like

obs = CALCULATETABLE (
obsolescences, filter(obsolescences, not(obsolescences[ccube osgroup.name] = "Sans OS indiqué" && obsolescences[type] <> 50))
)

[Anonymous]

yes it work thank you very much