Forum Discussion
Helper IIIHelp with getting the maximum value from calculated table containing measure column
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.
Community SupportHi miguelsus2000 ,
You could try to use the function of MAXX.
Measure =
CALCULATE (
MAXX ( 'LoRaBlePayload (2)', [Count per BID] ),
ALLEXCEPT (
'LoRaBlePayload (2)',
'LoRaBlePayload (2)'[Content.BeaconIdentifier]
)
)
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.
Helper IIIHi v-xuding-msft and thank you for yoru help. However, I get a "1" for the measure column. How did you not get a "1". Could it be the format you're using?. See below (I called the above measure is called "max4"):