Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Anonymous
Not applicable

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

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:

SupplierProjectLine ItemSpecific price
S2P1L15
S1P1L110
S3P1L125
S1P1L25
S2P1L210
S3P1L215
S1P1L320
S2P1L325
S3P1L330
S1P2L125
S2P2L135
S3P2L140
S1P3L120
S2P3L335
S3P3L320
S4P4L415
S1P2L215
S2P2L225
S3P2L230
S1P2L345
S2P2L350
S3P2L355

 

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

 

Line ItemLowest Bidding SupplierLowest Specific priceHighest Bidding SupplierHighest Specific priceAverage Specific price
L1S25S34022.85
L2S15S33016.66


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

2 ACCEPTED SOLUTIONS
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope thish helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

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

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope thish helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@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 

Uddhavchitre_0-1668270072806.png

 

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

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Greg_Deckler
Super User
Super User

@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])


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@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)

Uddhavchitre_0-1668189433090.png

Uddhavchitre_1-1668189841210.png

Thank you

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors