The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am trying to show daily employee hours, but am having issues. The image of the table model shows the relationship I have between date (dim_date), employee table (harersemployee) and payroll (harperspayroll) table. The image of the report is also shown (reference HRW Hours). What I believe is happening is that the payroll amount is summed for all employees and displaying that information. I am unsure why if I have a relationship between user account id and the date, why its not properly filtering the individual employee account. Any assistance is appreciated.
Hi @Surveys ,
You are refering to the HRW Hours column in your matrix correct? Usually when there is this type of values that are a single value acrros all the visualization has to do with relationships that don't exist between two tables.
Can you tell if the HRW hours comes from a different table than the Employee Name and how are they related? altough you have an image of the setup it's not very practical to make a mockup data if you can share one and expected result would be great.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
135 | |
114 | |
107 | |
71 | |
57 |
User | Count |
---|---|
240 | |
129 | |
122 | |
96 | |
94 |