Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
82 | |
79 | |
63 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |