Forum Discussion

Arunravi0001's avatar
Arunravi0001
Frequent Visitor
2 years ago
Solved

Need Help

Hi Everyone !                                 I'm seeking for solution for below scenario i have table like this  Requirement :Find out Count of "Positive"  Word Occurrence in Above tabl...
  • some_bih's avatar
    some_bih
    2 years ago

    Hi Arunravi0001 check new version below.

    Test count =
    IF (
        Sheet1[Type] = "Positive",
        CALCULATE (
            COUNTAX ( FILTER ( Sheet1, Sheet1[Type] = "Positive" ), Sheet1[Type] ),
            ALLEXCEPT ( Sheet1, Sheet1[ID] )
        ),0
    )

    Did I answer your question? Kudos appreciated / accept solution!

Arunravi0001's avatar
Arunravi0001
Frequent Visitor
2 years ago

Hi some_bih , Thanks for  Your reply 

Need Column be like , based on id , the "positive " word count 

 

Arunravi0001's avatar
Arunravi0001
Frequent Visitor
2 years ago

Thanks for this some_bih ðŸ™‚

  • some_bih's avatar
    some_bih
    Community Champion
    2 years ago

    Hi Arunravi0001 

    If this is solutin, accept so other member of community could use it. Thx