Error in the amount of the rows

[Antonio_Gomez]

Hello everyone, hoping all of you having a great day.

I need some help with this issue:

My totals are OK. But, the amount shown in the rows is not right.

The relationship of the tables is:

Where:

• "Empleado" is the table of the staff. So, every line is a employee. The link column is "EmpleadoId".

  EmpleadoId	CodigoPractico	Name
  1	021	Employee 1
  2	057	Employee 2
  3	013	Employee 3

• "EstadoMovimiento" is a table of the movement of transportation. A transport passes through different states. So, this table has in every line a diferent state for the several transport. For each diferent state (every row) I have an employee assigned to it, because this worker made the move. Then, I can have for one movement "MovimientoId" several states "TipoEstadoId" and the same employee "EmpleadoId" related to it. Like:

  MovimientoId	TipoEstadoId	EmpleadoId
  1	2	15
  1	4	15
  1	6	15

• "Movimiento" is the table of the movements and is linked to "EstadoMovimiento" by "MovimientoId" 

  MovimientoId	Other columns
  1
  2
  3

  The first image is a matrix with:
• Rows: CodigoPractico
• Columns: The years related to the movements
• Values: A measure Movement = CALCULATE(COUNT(Movimiento[MovimientoId])))

I don't why for the calculation of the rows PBI is like doubling the employees. Maybe is because of the table "EstadoMovimiento" like in this I have for the same movement "MovimientoId" several times the same employee "EmpleadoId".

I really need some help with this.

Thanking you in advance for your help.

Greeting,

Antonio

[v-eqin-msft]

Hi @Antonio_Gomez ,

Sorry for that the information you have provided is not making the problem clear to me.

Please provide me with more details about your table and your expected outputor share me with your pbix file after removing sensitive data.

You may refer to:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[Antonio_Gomez]

Hello @v-eqin-msft 

Thanks for the response, I was cleaning my data in order to send you my pbix and I could see the problem but I don't know how to fix it.

When in the table "EstadoMovimiento" two or more employees make one move, the PBI counts each employee as different movement but actually is the same movement.

For example, this happen in the "EstadoMovimiento" table. You can see that the movement 2 was made by the employees 17 and 15. In my case, the PBI shows a total of 2 movements but in the rows it would show 3.

MovimientoId	TipoEstadoId	EmpleadoId
1	2	15
1	4	15
1	6	15
2	2	17
2	4	15
2	6	15

By the other hand, I was looking how to send you my pbix. But, i don't know how to do it. So I put reduced data in the following tables:

You can see that the movement 840 was made by the employees 17 and 14.

This is the PBI table result. The total of movements is OK as it is 25. But, if you sum 5+7+2+6+2+3+1 is equal to 26.

I need a formula that the movement be assigned to one of the two employees. Because, the 

CantMov = count(Movimiento[MovimientoId]) doesn't work for me

Empleado's Table

EmpleadoId	Nombre Completo	Activo	CodigoPractico	UsuarioId
17	Employee Name 17	False	019	17
31	Employee Name 31	True	022	31
49	Employee Name 49	True		49
23	Employee Name 23	False	001	23
30	Employee Name 30	True	021	30
14	Employee Name 14	True	017	14
55	Employee Name 55	True	025	55

EstadoMovimiento's Table

EstadoMovimientoId	TipoEstadoId	MovimientoId	EmpleadoId
1	3	840	17
2	23	840	17
3	2	840	14
4	4	840	14
5	3	841	17
6	23	841	17
7	2	841	17
8	4	841	17
9	3	842	17
10	23	842	17
11	2	842	17
12	4	842	17
13	3	843	31
14	23	843	31
15	2	843	31
16	4	843	31
17	3	844	14
18	23	844	14
19	2	844	14
20	4	844	14
21	3	845	17
22	23	845	17
23	2	845	17
24	4	845	17
25	3	846	30
26	23	846	30
27	2	846	30
28	4	846	30
29	3	847	30
30	23	847	30
31	2	847	30
32	4	847	30
33	3	848	30
34	23	848	30
35	2	848	30
36	4	848	30
37	3	849	30
38	23	849	30
39	2	849	30
40	4	849	30
41	3	850	30
42	23	850	30
43	2	850	30
44	4	850	30
45	3	851	14
46	23	851	14
47	2	851	14
48	4	851	14
49	3	852	17
50	23	852	17
51	2	852	17
52	4	852	17
53	3	853	31
54	23	853	31
55	2	853	31
56	4	853	31
57	3	854	30
58	23	854	30
59	2	854	30
60	4	854	30
61	3	855	49
62	23	855	49
63	2	855	49
64	4	855	49
65	3	856	49
66	23	856	49
67	2	856	49
68	4	856	49
69	3	857	17
70	23	857	17
71	2	857	17
72	4	857	17
73	3	858	14
74	23	858	14
75	2	858	14
76	4	858	14
77	3	859	14
78	23	859	14
79	2	859	14
80	4	859	14
81	3	860	17
82	23	860	17
83	2	860	17
84	4	860	17
85	3	861	23
86	23	861	23
87	2	861	23
88	4	861	23
89	3	862	23
90	23	862	23
91	2	862	23
92	4	862	23
93	3	863	49
94	23	863	49
95	2	863	49
96	4	863	49
97	3	864	55
98	23	864	55
99	2	864	55
100	4	864	55

Movimiento's Table

MovimientoId	Fecha	BuqueId
840	sábado, 1 de enero de 2022	55
841	sábado, 1 de enero de 2022	75
842	sábado, 1 de enero de 2022	33
843	sábado, 1 de enero de 2022	28
844	sábado, 1 de enero de 2022	3
845	sábado, 1 de enero de 2022	105
846	sábado, 1 de enero de 2022	303
847	sábado, 1 de enero de 2022	99
848	sábado, 1 de enero de 2022	107
849	sábado, 1 de enero de 2022	87
850	lunes, 3 de enero de 2022	41
851	lunes, 3 de enero de 2022	17
852	lunes, 3 de enero de 2022	15
853	lunes, 3 de enero de 2022	66
854	lunes, 3 de enero de 2022	211
855	lunes, 3 de enero de 2022	157
856	lunes, 3 de enero de 2022	113
857	lunes, 3 de enero de 2022	155
858	lunes, 3 de enero de 2022	71
859	lunes, 3 de enero de 2022	145
860	lunes, 3 de enero de 2022	181
861	martes, 4 de enero de 2022	151
862	martes, 4 de enero de 2022	204
863	martes, 4 de enero de 2022	199
864	martes, 4 de enero de 2022	4