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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Uddhavchitre
Frequent Visitor

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/

@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

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

@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.