Dear All,
Here is my simplified model. There are three tables - Fact Table, Region table and Employee table. Sample data is as follows:
Fact table
Region table
Employee table
Relationship are defined in model as
Facttable[Employee] = Employee Table [ Employee]
Employee Table [ Region] = Region table [ Region]
My requirement is to build a pivot with Region Manager name and get the Total of appointments for each Manager. I use a simple measure
TotalAppointments=CALCULATE(sum(Fact_Table[Appointmentsdone]))
Here is how the data looks with this measure for employees and managers
How do I get Manager A same as Employee A i.e. 8, manager B =16 and Manager C =8.
Thanks!
Here is my simplified model. There are three tables - Fact Table, Region table and Employee table. Sample data is as follows:
Fact table
Region table
Employee table
Relationship are defined in model as
Facttable[Employee] = Employee Table [ Employee]
Employee Table [ Region] = Region table [ Region]
My requirement is to build a pivot with Region Manager name and get the Total of appointments for each Manager. I use a simple measure
TotalAppointments=CALCULATE(sum(Fact_Table[Appointmentsdone]))
Here is how the data looks with this measure for employees and managers
How do I get Manager A same as Employee A i.e. 8, manager B =16 and Manager C =8.
Thanks!