Min and Max of aggregated table

[Atifz]

Hi all,

This may seem like a really easy question but I can't seem to figure it out. I have the following calculated table in my visual and I just need to create measures to get the min and max values of the count and average columns. 

Group1	Group2	Count of Customers	Avg Sales
A	AA	125	100
B	BB	33	200
C	CC	567	300
D	DD	43	400

I need 4 measures:

Min customer count = 33

Max Customer Count = 567

Min Avg Sales = 100

Max Avg Sales = 400

Thanks

[amitchandak]

@Atifz , Like

calculate(min([count of customer]),all(Table))
calculate(max([count of customer]),all(Table))
calculate(min([Avg Sales]),all(Table))
calculate(max([Avg Sales]),all(Table))

all(table) can be removed or can be replaced on allselected(Table) depending on need

[Atifz]

hi @amitchandak 

Sorry, I wasn't clear in my original post. Group1 and 2 are from different tables in the data and customer count is count of customer ID's, I don't have a customer count measure.

The above table was created as a visual in Power BI.

[amitchandak]

@Atifz ,Can you share sample data and sample output.