Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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")
Proud to be a Super User!
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")
Proud to be a Super User!
Yes! thank you @ryan_mayu! I had to add the ELSE value in your solution to make it work. This helps a lot!
you are welcome
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
144 | |
104 | |
103 | |
82 | |
70 |