cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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!:
The Definitive Guide to Power Query (M)

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors