Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I Have a table (Click here to Sample) where there are our productions orders.
In this table i have Order number (Key_Odl), products parts that i need to make order (Codice articolo figlio) and i have a colum where i can see if parts are avaible to make orders, also i have a check box. I need to have in my dashboard one colum that let me know if the selected orders is "ok" or "not ok". I think that i need to countrows a single order and then count how many "Ok" i have. If Ok is equal to Number of item i can make my order if not i can't do.
I hope I was clear
Solved! Go to Solution.
Ciao @Supermat ,
you can try this
Column =
IF(
MINX(
FILTER(
'Facts7',
'Facts7'[Order] = EARLIER('Facts7'[Order])
),
'Facts7'[Check]
) = "NO",
"Not Deliver",
"To be Delivered"
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Perfect!!! Thx
Ciao @Supermat ,
you can try this
Column =
IF(
MINX(
FILTER(
'Facts7',
'Facts7'[Order] = EARLIER('Facts7'[Order])
),
'Facts7'[Check]
) = "NO",
"Not Deliver",
"To be Delivered"
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The colum work, but now there are some duplicated value