Forum Discussion
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...
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
Community Champion
Community ChampionHi 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
