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.
Hi All,
I have a simple table that is sliced by an employee. However, the Working Hours total does not sum correctly. Does anyone have any insight as to why?
Thanks!
Hi @kamil947,
Any update for this?
If you are faced with the measure expression get the wrong result on total level, you can take a look at the following blog about total level multiple aggregation calculation:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
What is the calculation you are using to calculate [Working Hours]?
Proud to be a Super User!
Currently I am not using a calculation. I have a table listing all of the [Working Hours]. I have the [Period] from the table below linked to my fact table. The fact table is then linked to another dim table with the employees listed.
Hi @kamil947,
Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
I feel like you're going to need to share more details about your situation. Like what your model and the relationships, which fields you are using in the visual, etc. Refer to How to Get Your Question Answered Quickly so we can assist you more efficiently.
Proud to be a Super User!
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |