biggest value

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