Forum Discussion
Solved
Show visual indicator when field has certain values
I have a table that will have a master item number (Parent Item ID) and then a child part number (Component Item ID). These are all tied to work orders which is another column in my table. I am try...
I got it to work by creating a measure instead of a calculated column:
Work Order Status = VAR vCountShort = CALCULATE ( COUNT ( BOM[Comp Short] ), ALLEXCEPT ( WKO, WKO[Work Order ID] ), BOM[Comp Short] = "Short" ) VAR vResult = IF ( vCountShort > 0, "Short", "OK" ) RETURN vResult
I got it to work by creating a measure instead of a calculated column:
Work Order Status =
VAR vCountShort =
CALCULATE (
COUNT ( BOM[Comp Short] ),
ALLEXCEPT ( WKO, WKO[Work Order ID] ),
BOM[Comp Short] = "Short"
)
VAR vResult =
IF ( vCountShort > 0, "Short", "OK" )
RETURN
vResult
That appears to have helped get what I need. I had to remove all columns except Work Order and the new measure you helped create but this will for sure work. Thank you for all your help on this!