web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Power Bi
Business Central forum
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Power Bi

Posted on by Community Member

Hello.

We created a Calculated Column 'Fill Rate' but would like to replace it with Measure.

How do you create a measure to calculate the percentage of the 2 columns? What DAX formula to use to create this measure?

The 'Fill Rate' must be the percentage between Order Qty Shipped vs Order Qty that will also calculate the % of their totals (12.00/15.00)

pastedimage1614056623197v1.png

Thanks.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans