Forum Discussion

Ronnie7's avatar
Ronnie7
Helper II
9 years ago
Solved

Issue with Filter &&&&

Hi,   I have tried to create a new  column and using the following DAX code: Incoming Messages = CALCULATE ( COUNTA(PS_Message[MessageName]), FILTER ( ALL ( PS_Message[MessageName] ), 'PS_Mess...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    && means all conditions are required. That formula will only return rows on which MessageName simultaneously is 1 - Incoming, 2- Received, and 3 - Sent. Which is impossible because one field can only have one value. You should be using || instead of &&.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

&& means all conditions are required. That formula will only return rows on which MessageName simultaneously is 1 - Incoming, 2- Received, and 3 - Sent. Which is impossible because one field can only have one value. You should be using || instead of &&.

Ronnie7's avatar
Ronnie7
Helper II
9 years ago

Makes total sense! thanks!

  • renanc's avatar
    renanc
    Helper II
    6 years ago

    Ronnie7 

    Hi, dude.
    You can do something like this:

     
    MeasureX = CALCULATE(
COUNTROWS(Table1);
FILTER(Table1;Table1[Column1] = "TEXT1"
&& Table1[Column1] = "TEXT2"
|| Table1[Column1] = "TEXT3"
|| Table1[Column1] = "TEXT4"
))


    When you set the "&&" expression it will block all other values to pop-up "different from starting with ||", so after you can just add each one specified text with || expression.