count the number of applications

[mina97]

i have the following data

order	stauts
216	submited
216	accepted
217	submited
217	resumited
217	accepted

i need to count the number of orders that got accepted without being reaplied so in this case it should give one order 
i wrote the following dax but it is NOT helping

AcceptedOrdersWithoutResubmit = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        'Table',
        'Table'[stauts] = "accepted" &&
        NOT (
            CALCULATE(
                COUNTROWS('Table'),
                FILTER(
                    'Table',
                    'Table'[order] = EARLIER('Table'[order]) &&
                    'Table'[stauts] = "resumited"
                )
            ) > 0
        )
    )
)

please help and thank you 

[v-junyant-msft]

Hi @mina97 ,

The following DAX might work for you:

AcceptedOrdersWithoutResubmit =
COUNTROWS(
    FILTER(
        'Table',
        'Table'[status] = "accepted" &&
        NOT(
            CALCULATE(
                COUNTROWS('Table'),
                FILTER('Table', 'Table'[status] = "resumited"),
                ALLEXCEPT('Table', 'Table'[order])
            ) > 0
        )
    )
)

The final output is shown in the following figure:

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mina97]

hey can you make it count the unique numbers order 

because i have other status and i do not want it to count them fore xample 

216	Sumbit
216	Review
216	Paid
216	Approved

the dax counted this as 4 😞 please help 

[v-junyant-msft · Accepted solution]

Hi, @mina97 ,

The following DAX might work for you:

UniqueOrdersCount = COUNTROWS(VALUES('Table(2)'[order]))

The final output is shown in the following figure:

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mina97]

it should be 1 

[mina97]

wrong it gived zero 😞

[Dangar332]

Hi, @mina97 

try below just adjust your table aand column name 

final =

var a = DISTINCTCOUNT('practice'[order])

var b = CALCULATE(DISTINCTCOUNT('practice'[order]),practice[status]="resumited")

return a-b

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. and don't forget to give kudos