Create measure that shows the percentage of late delivered orders, based on total amount, per city

[bbg]

Hello,

I have a PowerBI dataset showing the city, order amount and a column that says if the order was late or not. How can I create a measure that shows, for each city, the late orders amount as a percentage of total order amount for that specific city. See the Excel example below.

The "Late" column is itself a calculate column based on two date columns, if that matters. Thank you!

[bbg]

I tried again and it worked. Thanks!

[amitchandak · Accepted solution]

@bbg , Create measures like

Late = calculate(Sum(Table[order Amount]), filter(Table, table[Late] ="Yes") )

Late % = divide([Late], Sum(Table[order Amount]) )

[bbg]

Thanks, @amitchandak . My "Late" column indicator and my amount column are in different tables and the Late column does not show up when I type it in the formula bar, if that makes sense. Is that a condition for the two columns to be used in the same formula?