cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors