Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Multiple ALLEXCEPT for different tables

Dears, I have a report in where I need to show the total budget amount for the full year (ignoring months), and I also need to be able to filter between each area that is responsible for each expens...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi everyone,

 

I am having the same issue that in this topic apparently had no solution.

 

This is my case:

 

Tiempo_disp_Planta = CALCULATE

          (SUM(v_Partes[MinutosDisponibles]);

          ALLEXCEPT(v_Partes; v_Partes[NLinea]);

          ALLEXCEPT(v_ParadasxParte;v_ParadasxParte[NOEECategoria1]))

 

In a first step, I just used ALLEXCEPT(v_Partes; v_Partes[NLinea]) and everything went fine.

When I added ALLEXCEPT(v_ParadasxParte;v_ParadasxParte[NOEECategoria1]), the first ALLEXCEPT stopped working (as if it had been overwritten by the second one).

 

Could anyone help me?

Thanks a lot in advance.