Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Count per Progress Status

Hi good day,

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

 

Thank you

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

     

3 Replies

  • Irwan's avatar
    Irwan
    Super User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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