Forum Discussion

IoannisT's avatar
IoannisT
Advocate I
2 years ago
Solved

Count specific words separate by comma on row and exclude empty cells

Hi Fabric community.   I have had a search around and found partially the solution but I am having trouble excluding empty cells on the following count. They say 1 photo is 1000 words so here is t...
Need Help
  • Kishore_KVN's avatar
    Kishore_KVN
    2 years ago

    Hello IoannisT ,

    Please change your measure as below:

    DoA_Individual_Count = 
IF(MAXX('Table','Table'[Approved_Actions])<>BLANK(),
SUMX(
    'Table',
    LEN('Table'[Approved_Actions])
        -LEN(
            SUBSTITUTE(
                'Table'[Approved_Actions],
                ",",
                ""
             )
        )+1),0)

    Output looks as below:

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Kishore_KVN's avatar
Kishore_KVN
Solution Sage
2 years ago

Hello IoannisT ,

Please change your measure as below:

DoA_Individual_Count = 
IF(MAXX('Table','Table'[Approved_Actions])<>BLANK(),
SUMX(
    'Table',
    LEN('Table'[Approved_Actions])
        -LEN(
            SUBSTITUTE(
                'Table'[Approved_Actions],
                ",",
                ""
             )
        )+1),0)

Output looks as below:

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

  • IoannisT's avatar
    IoannisT
    Advocate I
    2 years ago

    Thank yo uso much. It works!