Countrows

[Supermat]

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

[Supermat]

Perfect!!! Thx

[mangaus1111 · Accepted 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.

[Supermat]

The colum work, but now there are some duplicated value