Forum Discussion

smillward's avatar
smillward
Frequent Visitor
9 years ago
Solved

Searching/Counting mutiple values from one cell

So currently i have a column storing multiple values in one cell (it captures answers from a multiple select survey),   So the column contains values such as 1.   Alpha 1 2.   Alpha 5 3.   Alpha...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi smillward,

     

    Based on my test, the formula below should work in your scenario. :smileyhappy:

    Measure =
CALCULATE ( COUNTROWS ( Table1 ), SEARCH ( "Alpha 1", Table1[Column],, 0 ) > 0 )
    - CALCULATE (
        COUNTROWS ( Table1 ),
        SEARCH ( "Alpha 1?", Table1[Column],, 0 ) > 0
            && SEARCH ( "Alpha 1,", Table1[Column],, 0 ) = 0
    )

     

    Regards

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
9 years ago

That the string "Alpha 10" contains "Alpha 1" as part of it is probably going to throw it off in some way?