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!

some_bih's avatar
some_bih
Community Champion
2 years ago

Hi Arunravi0001 possible solution as following calculated column

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

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

  • some_bih's avatar
    some_bih
    Community Champion
    2 years ago

    Hi Arunravi0001 please describe which criterias should be matched to get the figures as your overview- first occurance of Sample ID and Type is "Positive" or ...what about Sample3  and value 0?

    • Arunravi0001's avatar
      Arunravi0001
      Frequent Visitor
      2 years ago

      hi some_bih yes ,Sample ID and Type is "Positive" , should be counting  , if Negative Returns "0"

      • some_bih's avatar
        some_bih
        Community Champion
        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!