Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone.
Not really sure how to explain this properly, but I am trying to figure out a way to calculate all rows with one result based on the values in 2 other columns. Here is my example below.
So if any of the order numbers have a TRUE from my if statmenent I would like the new column to carry that true into all rows for that order number.
Order | Work True | Desired result |
10 | TRUE | TRUE |
10 | TRUE | TRUE |
10 | FALSE | TRUE |
20 | FALSE | FALSE |
20 | FALSE | FALSE |
20 | FALSE | FALSE |
30 | FALSE | TRUE |
30 | FALSE | TRUE |
30 | TRUE | TRUE |
Thanks
Solved! Go to Solution.
Hi @Dave403
Desired result = if(CALCULATE(COUNT(Table_2[Work True]),ALLEXCEPT(Table_2,Table_2[Order]), Table_2[Work True] = "TRUE")>=1,"TRUE","FALSE")
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @Dave403
Desired result = if(CALCULATE(COUNT(Table_2[Work True]),ALLEXCEPT(Table_2,Table_2[Order]), Table_2[Work True] = "TRUE")>=1,"TRUE","FALSE")
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi Pranit
Works perfectly, thanks for the help.
Dave
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |