cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Trying to calculate scrap rate %

Hello,

I'm brand new to Power BI and only started using it a few days ago. I am creating a report for my company and have to calculate the scrap rate of an axel from month to month. I believe that i need to count the number of times "Scrap" appears in the outcome column to count the scrap total and then count the number of times "Pass", "Re-Machine" and "Dress" appear as the outcome to count the production total. Then i divide the scraped total by the production total to calcualate the scrap rate %. I have to figure this out for every month over the past two years and compare the data found. Wondering what the best way to do this would be? I have created a table which i will include in a screenshot below, and just believe that i need to add the three measures listed above and then create the visuals from the data found.

Thanks!

1 ACCEPTED SOLUTION
Memorable Member

Hi @cwilsonLUR,

Start by creating the % Scrap by using the following formula:

``% Scrap = CALCULATE(COUNT('Table'[Outcome]), FILTER('Table','Table'[Outcome]="Scrap")) / COUNT('Table'[Outcome])``

Fomat this measure as a percentage. You can use this along with the month year column in a table or graph and see % Scrap for every month.

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI

Memorable Member

Hi @cwilsonLUR,

Start by creating the % Scrap by using the following formula:

``% Scrap = CALCULATE(COUNT('Table'[Outcome]), FILTER('Table','Table'[Outcome]="Scrap")) / COUNT('Table'[Outcome])``

Fomat this measure as a percentage. You can use this along with the month year column in a table or graph and see % Scrap for every month.

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors