Aggregation Measures for my data

Hi zachtatum ,

It seems that you data like the following:

Please have a try.

max_measure =
MAXX (
    FILTER ( ALL ( table ), table[brand] = SELECTEDVALUE ( table[brand] ) ),
    table[grossrev]
)

min_measure =
MINX (
    FILTER ( ALL ( table ), table[brand] = SELECTEDVALUE ( table[brand] ) ),
    table[grossrev]
)

AVERAGEX_measure =
AVERAGEX (
    FILTER ( ALL ( table ), table[brand] = SELECTEDVALUE ( table[brand] ) ),
    table[grossrev]
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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