Count per Progress Status

[AllanBerces]

Hi good day,

Can pls someone help me on how can I achieved the output i desired on my table below.

Thank you

[Anonymous · Accepted solution]

Thanks for the reply from Irwan , please allow me to provide another insight:

Hi, @AllanBerces 

The solution provided by Irwan, using a calculated column, is a good idea.To facilitate your understanding, I have created the following example. Please refer to the attached PBIX file in the post.

If you need it as a measure, you can refer to the following code:

Count measure =
COUNTX (
    FILTER (
        ALLSELECTED ( 'Table01' ),
        'Table01'[Trade] = MAX ( 'Table01'[Trade] )
            && 'Table01'[Status] = MAX ( 'Table01'[Status] )
    ),
    'Table01'[Trade]
)

The output is as follows:

You can also try the following calculated column:

Count1=
CALCULATE (
    COUNTROWS ( 'Table01' ),
    FILTER (
        ALLSELECTED ( 'Table01' ),
        'Table01'[Status] = EARLIER ( Table01[Status] )
            && 'Table01'[Trade] = EARLIER ( 'Table01'[Trade] )
    )
)

Count2 =
CALCULATE (
    COUNTROWS ( 'Table01' ),
    ALLEXCEPT ( 'Table01', Table01[Status], 'Table01'[Trade] )
)

Here's my final result, which I hope meets your requirements.

Best Regards,

Leroy Lu

[AllanBerces]

Hi @Anonymous @Irwan , thank you very much for the reply. work as i need

[Irwan]

hello @AllanBerces 

please check if this accomodate your need.

Count =
COUNTX(
    FILTER(
        'Table',
        'Table'[Trade]=EARLIER('Table'[Trade])&&
        'Table'[Status]=EARLIER('Table'[Status])
    ),
    'Table'[Trade]
)

Hope this will help.

Thank you.