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|
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|
Solved! Go to Solution.
@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
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])
@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)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.