Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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

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!

1 ACCEPTED SOLUTION
Super User

@bbg , Create measures like

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

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

3 REPLIES 3
Regular Visitor

I tried again and it worked. Thanks!

Super User

@bbg , Create measures like

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

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

Regular Visitor

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?

Helpful resources

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Power BI Monthly Update - July 2024

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

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors