Forum Discussion

Matthijs123456's avatar
Matthijs123456
Frequent Visitor
4 years ago

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 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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

  • Matthijs123456's avatar
    Matthijs123456
    Frequent Visitor
    4 years ago

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