DAX FILTER With or statement different tables

Question

Hello,&nbsp;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&nbsp;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&nbsp;Melding handmatig gewijzigd = CALCULATE (&nbsp; &nbsp; COUNTROWS ( Melding ),&nbsp; &nbsp; Melding[AanmaakGebruiker] &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = "1234",&nbsp; &nbsp; MeldingRegel[AanmaakGebruiker] &nbsp; &nbsp; &nbsp;= "1234",&nbsp; &nbsp; FILTER((Melding,Melding[MutatieGebruiker] &lt;&gt; "5678" &amp;&amp; Melding[MutatieGebruiker] &lt;&gt; "56789" &amp;&amp; Melding[MutatieGebruiker] &lt;&gt; "567810"), --&nbsp;OR--&nbsp; &nbsp; FILTER(MeldingRegel,MeldingRegel[MutatieGebruiker] &lt;&gt; "5678" &amp;&amp; MeldingRegel[MutatieGebruiker] &lt;&gt; "56789" &amp;&amp; MeldingRegel[MutatieGebruiker] &lt;&gt; "567810"))&nbsp; &nbsp; )&nbsp;amitchandak&nbsp;&nbsp;

amitchandak · Answer

Matthijs123456 , if this from same table you can try like 
&nbsp;
Melding handmatig gewijzigd =CALCULATE (COUNTROWS ( Melding ),Melding[AanmaakGebruiker] = "1234",MeldingRegel[AanmaakGebruiker] = "1234",FILTER((Melding,Melding[MutatieGebruiker] &lt;&gt; "5678" &amp;&amp; Melding[MutatieGebruiker] &lt;&gt; "56789" &amp;&amp; Melding[MutatieGebruiker] &lt;&gt; "567810") || ( MeldingRegel[MutatieGebruiker] &lt;&gt; "5678" &amp;&amp; MeldingRegel[MutatieGebruiker] &lt;&gt; "56789" &amp;&amp; MeldingRegel[MutatieGebruiker] &lt;&gt; "567810")))

matthijs123456 · Answer

Hello, these are two different tables. See below&nbsp;amitchandak&nbsp;CALCULATE&nbsp;(&nbsp; &nbsp;&nbsp;COUNTROWS&nbsp;( Melding ),&nbsp; &nbsp; Melding[AanmaakGebruiker] &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&nbsp;"1234",&nbsp; &nbsp; MeldingRegel[AanmaakGebruiker] &nbsp; &nbsp; &nbsp;=&nbsp;"1234",&nbsp; &nbsp;&nbsp;FILTER((Melding,Melding[MutatieGebruiker] &lt;&gt;&nbsp;"5678"&nbsp;&amp;&amp; Melding[MutatieGebruiker] &lt;&gt;&nbsp;"56789"&nbsp;&amp;&amp; Melding[MutatieGebruiker] &lt;&gt;&nbsp;"567810"), --&nbsp;OR--&nbsp; &nbsp;&nbsp;FILTER(MeldingRegel,MeldingRegel[MutatieGebruiker] &lt;&gt;&nbsp;"5678"&nbsp;&amp;&amp; MeldingRegel[MutatieGebruiker] &lt;&gt;&nbsp;"56789"&nbsp;&amp;&amp; MeldingRegel[MutatieGebruiker] &lt;&gt;&nbsp;"567810"))&nbsp; &nbsp; )

Forum Discussion

DAX FILTER With or statement different tables

2 Replies

Related content

Page Level filter for different groups

IF Statement with Filter

OR Statement ?

Different schema into different destination

SQL Statement opcion error