Sum of Min , Avg and Max Values

[8125551478]

Input Data

Country	State	Sales Amount
India	Hyderabad	150014
India	Delhi	185405
India	Mumbai	220796
US	Georgia	125405
US	Mexico	145405
US	New York	165405
UK	England	120245
UK	Scotland	169875
UK	Ireland	168472

Problem Statement: (New Measure / New Column)

Sum of Minimum sales of country =

Sum of Max sales of country =

Sum of Average sales of country =

Visual output =

Show Measure values as per slicer selection.

Slicer Selection:

India

US

UK

Card Output:

Min Value

Average Value

Max Value

[Greg_Deckler]

@8125551478 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.

[8125551478]

Thank You , also kindly sugest the below problem statement.

 calculate % Difference  with other countys (when compair total sales of india to other counters ,How much of % difference is coming )

Country	State	Sales Amount
India	Hyderabad	150014
India	Delhi	185405
India	Mumbai	220796
US	Georgia	125405
US	Mexico	145405
US	New York	165405
UK	England	120245
UK	Scotland	169875
UK	Ireland	168472