Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Show Max value for each item in a gallery

Hi,

 

 I am trying to show the max weight recorded for each exercise in a gallery.

I can successfully filter by specific numbers, but would like to use the Max function instead.

My query is as follows:

Filter(SortByColumns(
WorkoutLogs,"cr503_weightkg",
SortOrder.Descending
),'Weight (kg)'=84)

 

thanks in advance

3 Replies

  • rubayatyasmin's avatar
    rubayatyasmin
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi, Syndicate_Admin 

     

    see if this works. 

     

    Max Weight =
    CALCULATE (
    MAX ( WorkoutLogs[Weight (kg)] ),
    FILTER (
    ALL ( WorkoutLogs[Exercise] ),
    WorkoutLogs[Exercise] = MAX ( WorkoutLogs[Exercise] )
    )
    )

     

     

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    Thanks for the above,

     

     Unfortunately I need this for a PowerApps Gallery, so Power fx please.

    I'm unable to use a DAX measure.

     

    • rubayatyasmin's avatar
      rubayatyasmin
      Icon for Community Champion rankCommunity Champion
      3 years ago

      tried converting it.

       

      ClearCollect(
      MaxWeightsByExercise,
      ForAll(
      Distinct(WorkoutLogs, 'cr503_exercise'),
      LookUp(
      WorkoutLogs,
      'cr503_exercise' = Result,
      'Weight (kg)' = Max(Filter(WorkoutLogs, 'cr503_exercise' = Result), 'Weight (kg)')
      )
      )
      )

       

      sorry if it doesn't help you.