Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |