Forum Discussion

sandraemma's avatar
sandraemma
Frequent Visitor
3 years ago
Solved

biggest value

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  sandraemma ,

    I created some data:

     

    Here are the steps you can follow：

    1. Create measure.

    Find the entire data maximum:
ALL_Max =
MAXX(
    ALL('Table'),[Value])
    Find the maximum value of the data for each grouping:
Group_Max =
MAXX(
    FILTER(ALL('Table'),
    'Table'[Group]=MAX('Table'[Group])),[Value])

    2. Result:

     

    Best Regards,

    Liu Yang

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

     

2 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    you should just be able to use a MAX expression:

     

    Measure = CALCULATE(MAX('Table'[Status]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  sandraemma ,

    I created some data:

     

    Here are the steps you can follow：

    1. Create measure.

    Find the entire data maximum:
ALL_Max =
MAXX(
    ALL('Table'),[Value])
    Find the maximum value of the data for each grouping:
Group_Max =
MAXX(
    FILTER(ALL('Table'),
    'Table'[Group]=MAX('Table'[Group])),[Value])

    2. Result:

     

    Best Regards,

    Liu Yang

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