topic count the number of applications in DAX Commands and Tips

count the number of applications

mina97 — Mon, 23 Oct 2023 03:37:36 GMT

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

Re: count the number of applications

Dangar332 — Mon, 23 Oct 2023 03:46:21 GMT

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

Re: count the number of applications

mina97 — Mon, 23 Oct 2023 03:55:09 GMT

wrong it gived zero 😞

Re: count the number of applications

Anonymous — Tue, 24 Oct 2023 02:06:53 GMT

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.

Re: count the number of applications

mina97 — Tue, 24 Oct 2023 03:44:09 GMT

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

Re: count the number of applications

mina97 — Tue, 24 Oct 2023 03:44:32 GMT

it should be 1

Re: count the number of applications

Anonymous — Tue, 24 Oct 2023 05:17:25 GMT

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.