How to create table measure to return results equivalent to Table Visual (Groupby?)

[PhilSmith]

There a lot of tables involved in this, and it would be pretty hairy to get into all of the relationships here.  I have everything doing what I want in a table visual, so perhaps I will not need relationship details.

My table visual consists of three fields.  Customer[CustomerName], BrandCat[BrandCat], and Sales[BC-Goals Met]  You can ignore Sale.

BC-Goals-Met = CALCULATE(if(Sales[Sale]>50,"MET","UnMet"))  

Sale = CALCULATE(SUM(Sales[Ext_Price]),FILTER(Sales,Sales[Open_Sale]= "Sale"))

BC-Goals Met only makes sense in the context of each Customer and BrandCat combination.

Grouped by Customer and BrandCat, BC-Goals-Met is perfect, but the table visual below is doing the grouping.  Now I need a measure that returns a table of those same specific BC-Goals-Met, so that I can count the Met, UnMet, and total number of entries.

I think GROUPBY is the key here, but I am not sure how to apply it.

I am looking for something that would return BC-Goals-Met, as a table, idealy one that would return CustomerName, BrandCat, and BC-Goals-Met just like the visual.

[Greg_Deckler · Accepted solution]

@PhilSmith This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

Note, you can use GROUPBY in place of SUMMARIZE, depends on the need.