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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors