Forum Discussion
How to filter a measure by multiple values
You can use double pipe || as a logical or
=CALCULATE([measure], table[column 1] = 1 || table[column 1] = 2)
Or is a function that takes 2 parameters. Double pipe || is an inline syntax and you can have as many as you need.
You can use double pipe || as a logical or
=CALCULATE([measure], table[column 1] = 1 || table[column 1] = 2)
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])
That works, thank you!!
Or is a function that takes 2 parameters. Double pipe || is an inline syntax and you can have as many as you need.
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
what does [measure] mean in your example?
