Measures

Hi Patrycja,

Thank you for the forum question.


I'd be happy to help you with your Power BI measures. Let's break down the steps to achieve what you're looking for:

1. Calculating the % of 'Y' for Each Supplier
First, you'll need to create a measure to calculate the percentage of 'Y' values for each supplier.

Create a new measure for the count of 'Y':

CountY = CALCULATE(COUNTROWS(YourTable), YourTable[On Time Delivery] = "Y")
Create a measure for the total count of deliveries:

TotalDeliveries = COUNTROWS(YourTable)
Create the percentage measure:

PercentageOnTime = DIVIDE([CountY], [TotalDeliveries], 0)
2. Calculating Total Spend of 'Y' Lines for Each Supplier
Next, you'll need a measure to calculate the total spend for 'Y' lines.

Create a measure for the total spend of 'Y' lines:
TotalSpendY = CALCULATE(SUM(YourTable[Spend]), YourTable[On Time Delivery] = "Y")
3. Visualizing the Data
Now, you can visualize these measures in Power BI:

Create a table or matrix visual:

Add Supplier to the rows.
Add PercentageOnTime and TotalSpendY to the values.
Create a bar chart or other visual to compare total spend vs. on-time delivery:

Add Supplier to the axis.
Add TotalSpendY and PercentageOnTime to the values.
This should give you a clear comparison of total spend for each supplier versus their on-time delivery performance.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector