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 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.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |