Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |