Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count appearance of string in a comma-separated data column does not count values after the first co

I have two tables:   Products table has a single column with one product per field:           List table has several columns but the column I'm interested in has fields that can have as...
"FILTER"
CONTAINSSTRING
COUNTROWS
DAX
measure
Search
  • tamerj1's avatar
    tamerj1
    3 years ago

    Anonymous 
    Please delete or deactivate that relationship or use 

    Customer Products at M0 =
CALCULATE (
    SUMX (
        VALUES ( Products[Product] ),
        SUMX (
            VALUES ( Query1[M0_LIST] ),
            INT ( CONTAINSSTRING ( Query1[M0_LIST], Products[Product] ) )
        )
    ),
    CROSSFILTER ( Query1[M0_LIST], Products[Product], NONE )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

please try

Customer Products at M0 =
SUMX (
VALUES ( Products[Product] ),
SUMX (
VALUES ( Query1[M0_LIST] ),
INT ( CONTAINSSTRING ( Query1[M0_LIST], Products[Product] ) )
)
)