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 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'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!

7 Replies

  • 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