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
    9 years ago

    You can use double pipe || as a logical or

     

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

  • MattAllington's avatar
    MattAllington
    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. 

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])