How to evaluate multiple occurances of an ID in combination with IF statements

[joostvanham]

Hi,

I'm trying to do the following:

ID	A	B	C
x	0	1	2
y	1	1	1
x	1	0	0

I need to know which ID's have a value >0 for A, B and C. 

Based on the table above I expect both x and y to be returned.

I think I need a calculated column for this where I use EARLIER to evaluate all ID's in combination with a couple of IF statements. 

Hopefully you can help me in the right direction.

Cheers,

Joost

[ryan_mayu · Accepted solution]

@joostvanham 

is this what you want?

Column = 
var a=sumx(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[A])
var b=sumx(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[B])
var c=sumx(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[C])
return if(a>0&&b>0&&c>0,"Yes")

[joostvanham]

Yes! thank you @ryan_mayu! I had to add the ELSE value in your solution to make it work. This helps a lot!

[ryan_mayu]

you are welcome