cancel
Showing results 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

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:

 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?
@AlbertoFerrari @Greg_Deckler @amitchandak @Ashish_Mathur

2 ACCEPTED SOLUTIONS
Super User

Hi,

Hope thish helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
5 REPLIES 5
Super User

Hi,

Hope thish helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

@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

Super User

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
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])``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor

@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

Announcements

#### 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.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

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

Top Solution Authors
Top Kudoed Authors