I have 4 different tables with errors and error opportunity for different Site/location for each month.
I have created measure to get the consolidated error count from all 4 tables and another measure to get a consolidated error opportunity from all 4 tables.
These measures are in a table called Site_location which has only Site ID and Site Name.
What i need is Site wise error count and error opportunity for each month. however what I am getting is only the grand total of all error for site - not sure how to get month wise breakdown. how do i create relationship for month. Will share more details if required. Kindly help.
Sample data :
|Order Number||Month||Emp Name||Line||Site||Error||Error Opportunity|
Expected result for error % :
this is based on the calculation sum of errors for UK for June divided by sum of error opportunities for UK for June eg., for June Uk had 2 errors divided by 2 error opportunities
later will have to present this in chart format
Hi @Seer_Bug ,
You can create a measure as below:
error % = DIVIDE(SUM('Site info'[Error]),SUM('Site info'[Error Opportunity]),0)
Hi @Seer_Bug ,
Could you please provide the structure and sample data of these 4 tables and existed relationships among these 4 tables?
Thanks for responding. with one table i have done the sum, However i have 4 such different table, wherein I need the output as a consolidation from all tables month wise
@Seer_Bug Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.