Forum Discussion

Kashuo's avatar
Kashuo
Icon for Helper I rankHelper I
9 years ago
Solved

How to filter a measure by multiple values

Hello, I would like to create a measure that returns the count of the rows of a table. I am able to use CALCULATE with a single value in the filter expression to get the measure to return the correct...
Need Help
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

You can use double pipe || as a logical or

 

=CALCULATE([measure], table[column 1] = 1 || table[column 1] = 2)

  • v-alhans's avatar
    v-alhans
    New Member
    8 years ago

    When I use that formula, I get the error "The expression contains multiple columns, but only a single column ca be used in a True/False expression that is used as a table filter expression".

     

    My measure is: COUNTA('table[Column])

  • Kashuo's avatar
    Kashuo
    Icon for Helper I rankHelper I
    9 years ago

    That works, thank you!!

    • MattAllington's avatar
      MattAllington
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Or is a function that takes 2 parameters. Double pipe || is an inline syntax and you can have as many as you need. 

      • LukasV89's avatar
        LukasV89
        Frequent Visitor
        9 years ago

        Hello Matt,

         

        Is there a way to use the || to sort byt two columns?

         

        I have a total ranking of mutiple columns columns. However, I also have a column with the number of surveys the customer took. I need to rank all customers with more than 10 surveys in the upper half of my table but then I also need to rank those with less than 10 surveys in the lower half of the table. Any suggestion on how to do that?

         

        Thank you,

         

        Lukas

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    what does [measure] mean in your example?