Finding a minimum, maximum and average for a product along with slicer

[Anonymous]

Hello,
I want to show minimum, maximum and average price for particular line item along with its supplier and should be able to use slicer for project.
Following is the data:

Supplier	Project	Line Item	Specific price
S2	P1	L1	5
S1	P1	L1	10
S3	P1	L1	25
S1	P1	L2	5
S2	P1	L2	10
S3	P1	L2	15
S1	P1	L3	20
S2	P1	L3	25
S3	P1	L3	30
S1	P2	L1	25
S2	P2	L1	35
S3	P2	L1	40
S1	P3	L1	20
S2	P3	L3	35
S3	P3	L3	20
S4	P4	L4	15
S1	P2	L2	15
S2	P2	L2	25
S3	P2	L2	30
S1	P2	L3	45
S2	P2	L3	50
S3	P2	L3	55

I am Expected to show data somthing like this. Also I want to use slicer for project

Line Item	Lowest Bidding Supplier	Lowest Specific price	Highest Bidding Supplier	Highest Specific price	Average Specific price
L1	S2	5	S3	40	22.85
L2	S1	5	S3	30	16.66

How can I do it?
Thank you in advance
@AlbertoFerrari @Greg_Deckler @amitchandak @Ashish_Mathur 

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope thish helps.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope thish helps.

[Anonymous]

@Ashish_Mathur Thanks a lot for the solution.
It means a lot.
Also I would like to ask it is possible to show sum of lowest price, highest price and average price in the Total row?
I am attaching sample 

[Ashish_Mathur · Accepted solution]

You are welcome.  Download the revised PBI file from here.

Hope this helps.

[Greg_Deckler]

@Anonymous Maybe:

Lowest Specific Price = MIN('Table'[Specific Price])

Lowest Bidding Supplier = MAXX(FILTER('Table',[Specific Price] = [Lowest Specific Price],[Supplier])

Highest Specific Price = MAX('Table'[Specific Price])

Highest Bidding Supplier = MAXX(FILTER('Table',[Specific Price] = [Highest Specific Price],[Supplier])

Average Specific Price = AVERAGE('Table'[Specific Price])

[Anonymous]

@Greg_Deckler Thank you so much for the reply.
I tried to use your solution but in the column of Lowest Bidding Supplier; it is giving wrong values
Please find attached screen shots of the Power BI file and Excel file(Answer should look like this)

Thank you