topic Re: Need Help in DAX Commands and Tips

Need Help

Arunravi0001 — Wed, 04 Oct 2023 09:12:08 GMT

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

Re: Need Help

some_bih — Wed, 04 Oct 2023 10:07:38 GMT

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

Re: Need Help

Arunravi0001 — Wed, 04 Oct 2023 10:37:39 GMT

Hi some_bih , Thanks for Your reply

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

Re: Need Help

some_bih — Wed, 04 Oct 2023 11:14:13 GMT

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?

Re: Need Help

Arunravi0001 — Wed, 04 Oct 2023 12:57:24 GMT

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

Re: Need Help

some_bih — Wed, 04 Oct 2023 13:56:53 GMT

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!

Re: Need Help

Arunravi0001 — Wed, 04 Oct 2023 14:07:38 GMT

Thanks for this some_bih 🙂

Re: Need Help

some_bih — Wed, 04 Oct 2023 17:42:18 GMT

Hi Arunravi0001

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