Need Help

[Arunravi0001]

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 table based on ID column  

I Tried that using below DAX ,but it is not working 
Result =
var Table A = 
    summarize( Table name , ID,"Occurrence",
                                                                      if (Result[Type]="Positive", Count( [Type]),0)
                      )

return 
       countx=(Table A , "Occurrence")

Anyone please help me 

[some_bih]

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]

Hi @some_bih , Thanks for  Your reply 

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

[Arunravi0001]

Thanks for this @some_bih 🙂

[some_bih]

Hi @Arunravi0001 

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

[some_bih]

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]

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

[some_bih · Accepted solution]

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!