Forum Discussion
Highlighting ID's with missing work types
Hi Anonymous ,
I add some data：
Here are the steps you can follow：
1. Create measure.
Measure =
var _1=SELECTCOLUMNS('Invoice details',"1",[Task ID])
return
IF(
NOT( MAX('Product Table'[Task ID])) in _1,"red")2. Format – Conditional formatting.
3. Enter the Background color interface.
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi,
I think there has been some confusion with regards to what I am trying to achieve.
Dataset 1 shows task ID's that have had either an Erect or Dismantle invoice record added to them. Each task ID should have an Erect & Dismantle record but sometimes this can be missed.
I want to be able to highlight Task ID's that only have an Erect or Dismantle (I.e missing either an Erect or Dismantle)
Looking at the below dataset Task ID 1 & 2 will need to be highlighted as they only have Erect invoice records and are missing the Dismantle.
Dataset 1 - Invoice details
| Task ID | Work Type | Cost |
| 1 | Erect | 10 |
| 2 | Erect | 30 |
| 3 | Erect | 80 |
| 3 | Dismantle | 40 |
I hope this clears things up.