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 expense.

 

In order to do that I've came up with the following measure:

 

CALCULATE(
    SUM(BUDGET[AMOUNT]);
    BUDGET[TYPE] = "B";
    ALLEXCEPT(CC_OWNERS; CC_OWNERS[COST CENTER_OWNER]);
    ALLEXCEPT(BUDGET_PRIMES; BUDGET_PRIMES[EXPBUD.PRIME_DESC]);
    ALLEXCEPT(BUDGET; BUDGET[MONTH-YEAR])
)

 

However it is not working, since when I click in the filter that I would like to do (COST CENTER_OWNER and EXPBUD.PRIME_DESC) the context does not change.

Need Help

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    By my tests, I cannot reproduce your issue.

    If it is convenient, could you share some data sample which could reproduce your issue so that we could help further on it?

    Best Regards,

    Cherry

     

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please share some data sample and your desired output.

    Best  Regards,

    Cherry

     

  • 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.