Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?
Thank you in advance
@AlbertoFerrari @Greg_Deckler @amitchandak @Ashish_Mathur
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope thish helps.
You are welcome. Download the revised PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope thish helps.
@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
You are welcome. Download the revised PBI file from here.
Hope this helps.
@Anonymous 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])
@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
User | Count |
---|---|
101 | |
69 | |
58 | |
47 | |
47 |