the same database give two different answers?

[Anonymous]

Why does the same database give 2 different answers? See below on the photo. The hours that our employes worked on a project is not the same. And that only for 1 project P18-00400?? I really do not understand it.

[quentin_vigne]

Hi @Anonymous

Are both the table filtered by the slicer ? Try to look at interactions if they are the same

- Quentin

[Anonymous]

yes, same slicer. No interaction. I also did an export to excel to verify an I get always the right answer (the upper table). 

And it seems that it is the only project with this problem. I tought that the number was in text or something lik that. But no...

It is soooo strange and the answer will be so simple. Ia m sure of that.

[quentin_vigne]

@Anonymous

Are both of your table displaying same kind of values ? Like the sum of hours and not the count or distinct count of hours ? 

- Quentin

[Anonymous]

no that is not the problem. As you can see it does not happen with every project. And the project with the problems gives the rigt numbers and  the wrong numbers (two times the amount of the right numbers). The only differnce is that it is one time a matrix and the outher time a table. And I do not see the same problem with other projects???

[quentin_vigne]

@Anonymous

Could you please share with us a sample of your data (copy and paste some rows of your table here) ? I will try to solve the problem

- Quentin

[Anonymous]

found it 🙂

[v-yuta-msft]

Hi CindyBelgium,

Please check if there're duplicate rows like below:

gewerkt per project               Attribute                             datum
9                                            Dieter Van Langenhove      12/03/2018

12                                          Bart Devolder                      8/03/2018

9                                            Dieter Van Langenhove      12/03/2018

12                                          Bart Devolder                      8/03/2018

Matrix will sum up same values, while table will remove other same values.

Regards,

Jimmy Tao