Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
106 | |
90 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |