Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two data tables
The two tables currently linked through [Employee Dim] and [PO Dim].
DAX for Hours Diff used is:
I am trying to show the difference between the Actual hours and the Expected hours. This is proving difficult.
The issue is my filters are all from Actual Hours table (eg. Manager). When these are used they don't seem to filter out the irrelevant data…
eg.
X - axis is "Employees"
in this visual I only want to show the employees that's under, say Manager A. Not all the employees. I am not sure if it's the way the tables are linked or the way the DAX is written.
Hoping someone can shed some light on what I can do to correct this.
@Anonymous , You need to create common table like Employee(Employee manager) , PO, Date/Month and analyze data against common dimension
then sum('Expected Hour'[Hours]) - sum('Actual Hour'[Hours])
should work
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
Try to me in Star Shema
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Hi @amitchandak
Thanks for the quick response. I have two 'common' tables for Employees and PO, which are then linked to both tables in question (as mentioned above).
@Anonymous , Date is also needed, Then you can add employee, manager from employee, PO and date from date and measure like this one
sum('Expected Hour'[Hours]) - sum('Actual Hour'[Hours])
In a visual
Ah good point.. dates were also joined through a Date table, but I'd used the wrong date field in table one. Fitlers working now thanks. But the amount brought back when I use
sum('Expected Hour'[Hours]) - sum('Actual Hour'[Hours])
is the same for each field.
User | Count |
---|---|
92 | |
87 | |
77 | |
73 | |
68 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |