Forum Discussion
Creating flag at a different grain
Hi,
Below is my data. All im trying to do is for each city im checking if Vaccine is Polio and Covid then Flag = 1(for all rows of that city)
If a city doesn't have both the values then it is 0. Need to do this in DAX. Please help
| City | Vaccine | Flag(Output) |
| Mumbai | Covid | 1 |
| Mumbai | Polio | 1 |
| Hyderabad | Polio | 0 |
| Bangalore | Covid | 0 |
| Goa | Polio | 1 |
| Goa | Covid | 1 |
| Goa | HB | 1 |
Anonymous try this expression:
Flag Column = VAR __isPolio = CALCULATE ( COUNTROWS ( Table ), ALLEXCEPT ( Table, Table[City] ), Table[VaccineFlag] = "Polio" ) VAR __isCovid = CALCULATE ( COUNTROWS ( Table ), ALLEXCEPT ( Table, Table[City] ), Table[VaccineFlag] = "Covd" ) ) RETURN IF ( __isPolic >=1 && __isCovid >= 1, 1, 0 )Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
1 Reply
Anonymous try this expression:
Flag Column = VAR __isPolio = CALCULATE ( COUNTROWS ( Table ), ALLEXCEPT ( Table, Table[City] ), Table[VaccineFlag] = "Polio" ) VAR __isCovid = CALCULATE ( COUNTROWS ( Table ), ALLEXCEPT ( Table, Table[City] ), Table[VaccineFlag] = "Covd" ) ) RETURN IF ( __isPolic >=1 && __isCovid >= 1, 1, 0 )Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡