Forum Discussion
Row level value check if value null return warning if value available it will return Available
I have single table name called Local FPV. please find the below sample Data set item BOM BOM Level Plant Item(BOM) 2D-Length 2D-Width weight[g...
amitchandak
Super User
Super UserAnonymous , Try a measure like
ALERT = IF(countx(filter(allselected(LOCALFPV), LOCALFPV[Itemcode] = max(LOCALFPV[Itemcode])
&& LOCALFPV[Plant] = max(LOCALFPV[Plant]) && Isblank([weight]) ), LOCALFPV[Itemcode] ) >0 ,"WARNING","AVAILABLE")
amitchandak sir i am tried above measure but i am getting available only for the all the item code