Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Matthijs123456
Frequent Visitor

DAX FILTER With or statement different tables

Hello,

 

How do i place between these two different tables an OR statement? I want to create that it is one of these two table it is not equal to some data

 

In bold i have setup where i want to say the or statement. The brackets where it needs to be closed i also make bold

 

Melding handmatig gewijzigd =
CALCULATE (
    COUNTROWS ( Melding ),
    Melding[AanmaakGebruiker]           = "1234",
    MeldingRegel[AanmaakGebruiker]      = "1234",
    FILTER((Melding,Melding[MutatieGebruiker] <> "5678" && Melding[MutatieGebruiker] <> "56789" && Melding[MutatieGebruiker] <> "567810"), -- OR--
    FILTER(MeldingRegel,MeldingRegel[MutatieGebruiker] <> "5678" && MeldingRegel[MutatieGebruiker] <> "56789" && MeldingRegel[MutatieGebruiker] <> "567810"))
    )
 

 

2 REPLIES 2
amitchandak
Super User
Super User

@Matthijs123456 , if this from same table you can try like

 

Melding handmatig gewijzigd =
CALCULATE (
COUNTROWS ( Melding ),
Melding[AanmaakGebruiker] = "1234",
MeldingRegel[AanmaakGebruiker] = "1234",
FILTER((Melding,Melding[MutatieGebruiker] <> "5678" && Melding[MutatieGebruiker] <> "56789" && Melding[MutatieGebruiker] <> "567810") ||
( MeldingRegel[MutatieGebruiker] <> "5678" && MeldingRegel[MutatieGebruiker] <> "56789" && MeldingRegel[MutatieGebruiker] <> "567810")
)
)

Hello, these are two different tables. See below @amitchandak 

CALCULATE (
    COUNTROWS ( Melding ),
    Melding[AanmaakGebruiker]           = "1234",
    MeldingRegel[AanmaakGebruiker]      = "1234",
    FILTER((Melding,Melding[MutatieGebruiker] <> "5678" && Melding[MutatieGebruiker] <> "56789" && Melding[MutatieGebruiker] <> "567810"), -- OR--
    FILTER(MeldingRegel,MeldingRegel[MutatieGebruiker] <> "5678" && MeldingRegel[MutatieGebruiker] <> "56789" && MeldingRegel[MutatieGebruiker] <> "567810"))
    )



Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.