Forum Discussion
Total Not Footing in Table
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!
5 Replies
What is the calculation you are using to calculate [Working Hours]?
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.
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.
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
