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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.