Forum Discussion

hashtag_pete's avatar
hashtag_pete
Icon for Helper V rankHelper V
4 years ago
Solved

count occurences of multiple values

Hello community,  I struggle with the following request: I count the occurence of a certain value (here 50) in multiple columns with this query let source = #table( {"Width A", "...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Change each _ = 50 to

    each _ = 50 or _ = 45

hashtag_pete's avatar
hashtag_pete
Icon for Helper V rankHelper V
4 years ago

OMG... unbelievable... I knew the solution would be simple, but these syntax errors always give me rest...

Thanks so much.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Tip: If you need to check for more than just a couple of values, you can use List.Contains instead of a bunch of comparisons combined with "or".

 

For example, instead of

each _ = 50 or _ = 49 or _ = 48 or _ = 47 or _ = 46 or _ = 45

write the following:

each List.Contains({50,49,48,47,46,45}, _)
  • hashtag_pete's avatar
    hashtag_pete
    Icon for Helper V rankHelper V
    4 years ago

    Thanks, AlexisOlson , I was looking for something similar to the IN statement in DAX, but wasn't succesfull. 

    This defenitely helps!