Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
123 | June | AB | V | UK | 1 | 1 |
23 | June | rt | W | USA | 0 | 2 |
34 | July | YU | V | USA | 0 | 1 |
45 | July | AB | V | UK | 0 | 1 |
1 | June | AB | V | UK | 1 | 1 |
2 | June | rt | W | USA | 0 | 2 |
4 | July | YU | V | USA | 1 | 1 |
3 | July | AB | V | UK | 0 | 1 |
Expected result for error % :
Site | June | July |
UK | 100% | 0% |
USA | 0% | 50% |
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)
Best Regards
Rena
Hi Rena, thanks for responding, i have 4 such tables where i need to consolidate similar data month wise.
Hi @Seer_Bug ,
Could you please provide the structure and sample data of these 4 tables and existed relationships among these 4 tables?
Best Regards
Rena
OK @Seer_Bug, using your updated information I did this:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.