Total Not Footing in Table

[kamil947]

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!

[Anonymous]

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

[ChrisMendoza]

What is the calculation you are using to calculate [Working Hours]?

[kamil947]

@ChrisMendoza 

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.

[Anonymous]

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

[ChrisMendoza]

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.