Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |