Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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] Itemcode
Shipping case 70 Case - CAS CZ71 70.W398 293 236 324 FW001691.13
Shipping case 87 Case - CAS DE19 70.W398 293 236 321 FW001691.13
Square TIN BODY 70 PAK1 - PAK1 CZ71 87.1445 226 112 30 FW001691.13
Square TIN BODY 87 PAK1 - PAK1 DE19 87.1445 226 112 FW001691.13
Now i am adding the weight[g] value based on the Itemcode like below added table graph
Itemcode Plant weight
FW001691.13 CZ71 354
FW001691.13 DE19 321
Next trying add new column if weight[g] value null in Particular Itemcode any column . it will be warning i have added below dax code
ALERT = IF(LOCALFPV(weight[g]=BLANK(),"WARNING","AVAILABLE")
when i add this column in to the above i am getting duplicate code
Itemcode Plant weight ALERT
FW001691.13 CZ71 354 AVAILABLE
FW001691.13 CZ71 354 WARNING
FW001691.13 DE19 321 AVAILABLE
FW001691.13 DE19 321 WARNING
But Expect output Correct result below
Itemcode Plant weight ALERT
FW001691.13 CZ71 354 WARNING
FW001691.13 DE19 321 WARNING
Looking for support . thanks in advance .
@THENNA_41 , 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |