Forum Discussion
How to link between two charts?
It was fixed by adding a relationship between the tables with the MES column.
Thank you!
Best regards.
Nice day. The file is in Spanish. What language do you want to translate it into?
There I separated the four graphics more clearly on a single screen:
1) Total billing graph (correct values: the sum of all the months gives $486,250,492)
2) Percentage of training that gives error.
3) Training Chart
4) Total billing per month (there you can see the error that the total shown is 323,081,275, that's why you miscalculate the percentage).
How could I correct it?
I attach the link to the file
https://drive.google.com/file/d/1VL8NpMeIeB-fx2JTxaUATOlyriNFroZE/view?usp=sharing
Hi ,
The problem occurs because the total monthly Gastos used in the percentage calculation is incorrect it shows only a partial sum instead of the full monthly billing (Facturación). This causes the calculated percentages (such as for Training in April) to be much lower than they should be. Ensure that the [GastosTotales_Mensuales] measure accurately calculates the total Gastos for each month, not a sum over the entire dataset or an incorrectly filtered value. You can achieve this by applying the ALLEXCEPT() or KEEPFILTERS() function in the measure to maintain the month context.
GastosTotales_Mensuales =
CALCULATE(
SUM('Gastos'[Valor]),
ALLEXCEPT('Gastos', 'Gastos'[Mes]))
With this, the percentage measure will correctly reflect the month-by-month values:
Porcentaje_NoFacturable =
DIVIDE(
SUM('NoFacturables'[Valor]),
[GastosTotales_Mensuales],
0
)
Also, please translate the file into English to help us better understand the fields and logic and provide more accurate response.
Regards,
Karpurapu D.
Good day, how are you?
I did what you say, and it's still the same.
Total turnover = calculate(sum('Invoicing, fixed expenses and wage bill'[Aluar])+sum('Invoicing, fixed expenses and wage bill'[Fate])+[Deriv. madryn], ALLEXCEPT('Invoicing, fixed expenses and wage bill','Invoicing, fixed expenses and wage bill'[MES]))It seems to me that the problem is not there, but that the different tables do not synchronize with the MES column. Each table has its MES column and they are not related. I made a relationship with calenadario MES and the problem remains the same. The billing sum is not done correctly.It was fixed by adding a relationship between the tables with the MES column.
Thank you!
Best regards.
Thank you for providing the update. We are pleased to know that your issue has been resolved.