How to link between two charts?

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.