Count the highest value in table

Hi Steels_Cat 

Thank you very much mh2587 for your prompt reply.

Pls try this:

Create measures.

First query the maximum value in each group [Project], marked as 1.

MaxValues = 
IF(
    SELECTEDVALUE('Table'[Value]) = 
    CALCULATE(
        MAX('Table'[Value]),
        FILTER(
            ALL('Table'),
            'Table'[Project] = MAX('Table'[Project])
        )
    ),
    1,
    BLANK()
)

Counts the values that are 1 in each group [Cycle].

Count Cycle = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        'Table',
        'Table'[Cycle] = MAX('Table'[Cycle])
        &&
        'Table'[MaxValues] = 1
    )
)

Here is the result.

Regards,

Nono Chen

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

Hi,

PBI file attached.

Hope this helps.