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.
Hello,
I have 3 tables; viewProdRemedyIncidentServicesSla(TableA), viewProdRemedyWorkorders(TableB) amd Date Table.
TableA has measure to calculate resolved tickets. Calculation is as below -
INCIDENT COUNT RESOLVED =
CALCULATE (
DISTINCTCOUNT ( viewProdRemedyIncidentServicesSla[INCIDENT NUMBER] ),
FILTER (
ALL ( viewProdRemedyIncidentServicesSla ),
( viewProdRemedyIncidentServicesSla[STATUS] = "Closed"
|| viewProdRemedyIncidentServicesSla[STATUS] = "Resolved" )
&& viewProdRemedyIncidentServicesSla[WeekNumberResolved]
= MAX ( viewProdRemedyIncidentServicesSla[WeekNumberSubmit] )
&& viewProdRemedyIncidentServicesSla[INCIDENT LAST RESOLVED DATE].[Year] = 2018
)
)
Even Table B has a measure to calculate Resolved Ticket
WORKORDER COUNT RESOLVED =
CALCULATE (
COUNT ( viewProdRemedyWorkorders[WORK ORDER ID] ),
FILTER (
ALL ( viewProdRemedyWorkorders ),
( viewProdRemedyWorkorders[STATUS] = "Closed"
|| viewProdRemedyWorkorders[STATUS] = "Completed" )
&& viewProdRemedyWorkorders[WeekNumberResolved]
= MAX ( viewProdRemedyIncidentServicesSla[WeekNumberSubmit] )
&& viewProdRemedyWorkorders[ACTUAL END DATE].[Year] = 2018
)
)
Where as Date table has columns like Date, DateKey, WeeklyDuration. TableA and TableB have relationship with Date table using DateKey column.
So using this how will I be able to create a stack bar visual. For eg. Stack Bar should look like below.
Any help is appreciated
Thanks in Advance
Hi ashaikh,
Does the table structure in 'viewProdRemedyIncidentServicesSla' and 'viewProdRemedyWorkorders' same with each other? If they are, you could add the datekey column to both tables, add a column to TableA which has value 'TableA' as legend column, add a column to TableB which has value 'TableB' as legend column. Then append the two tables, after applied&closed, you can drag column Date[Datekey] as X-axis column, drag legend column as legend.
Regards,
Jimmy Tao
@v-yuta-msft the table dont have same structure. But as I have mentioned all three tables are related to each other using DateKey column.
Hi ashaikh,
Could you share some sample data if possible?
Regards,
Jimmy Tao
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.
User | Count |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |