Need help extracting Max Value.

[miguelsus2000]

Hi,

I'm trying to create a column in the bottom table which displays the maximum value under "Count per BID" for every PartitionKey value.  For example, i selected PartitionKey 70b...120, and the maximum Count per BID (see table above) is 61, so i'd like to display "61" in a column for that PartitionKey.  Can someone help me with the formula?  I'm stuck with Max3 and Max5, but the values are incorrect.  Thank you.

max3 =

CALCULATE (

    MAXx( 'LoRaBlePayload (2)', COUNTx('Key Measures', [Count per BID] )),

    ALLEXCEPT (

        'LoRaBlePayload (2)',

        'LoRaBlePayload (2)'[PartitionKey]

    )

)

Max5 =

MAXX (

    SUMMARIZE (

        FILTER (

            ALLSELECTED ( 'LoRaBlePayload (2)' ),

            'LoRaBlePayload (2)'[Content.BeaconIdentifier]

                IN FILTERS ( 'LoRaBlePayload (2)'[Content.BeaconIdentifier] )

        ),

        'LoRaBlePayload (2)'[Content.BeaconIdentifier],

        'LoRaBlePayload (2)'[PartitionKey],

        "New", [Count per BID]

    ),

    [New]

)

[stevedep · Accepted solution]

Hi,

Perhaps I am oversimplifying things, but this is my result:

MaxOfPartitionKey = maxx(SUMMARIZE('Table';'Table'[PartitionKey];'Table'[Identifier]);CALCULATE(COUNT('Table'[BID])))

As can be seen here:

Power BI file available here.

Please accept as solution if this is what you are looking for. Thanks.

Kind regards,

Steve. 

[miguelsus2000]

THank you Steve!  This worked very well!