Solved: Help with getting the maximum value from calculate... - Page 2

miguelsus2000 · ‎12-15-2019

Hi... i only want to display the maximum of each group for the calculated table below. For example, for 0000-1040I =32, for 1040O=32, 10413=43, etc. When i use MAX it complains the Counter per BID is a measure value. It really can't be that difficult to display these (then i'll graph them too). Thank you... M

v-xuding-msft · ‎12-23-2019

Hi @miguelsus2000 ,

Miguel, I tested your sample data. Maybe the following formula can help you. For why you get the sum value, I think it is caused that my sample is too simple. It is filtered by other columns in your actual data.

MAXX = 
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]
)

Best Regards,

Xue Ding

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

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

View solution in original post