Forum Discussion

8 Replies

      • mickey64's avatar
        mickey64
        Super User
        2 years ago

        For your reference.

        Sum_Count = CALCULATE(SUM(DATA[Count]),ALLEXCEPT('DATA','DATA'[Week No.],'DATA'[Phase],'DATA'[Trade]))

         

        Sum_Outcome = CALCULATE(SUM(DATA[Outcome]),ALLEXCEPT('DATA','DATA'[Week No.],'DATA'[Phase],'DATA'[Trade]))

         

         

  • sivarajan21's avatar
    sivarajan21
    Post Prodigy
    2 years ago

    Hi AllanBerces ,

     

    PFA measure to achieve your outcome

    Sumxperweek = 
CALCULATE(COUNTAX(Trade,Trade[Phase]),ALLEXCEPT(Trade,Trade[Phase],Trade[Week No.]))

     

    The result is:

     

    If you are satisfied with this, please accept it as a solution and give a kudos.

    Thanks in advance!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    On week 27, there is only 1 combination of Com and Mech.  Shouldn't the answer be 1?  In Week 28, for the same combination of Com and Mech, shouldn't the answer be 3?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, AllanBerces 

        Glad to know that you appear to have found a solution.

         

        Could you please share your solution and mark it as a solution? This will help other members of the community who are experiencing similar problems to yours to be able to find a solution faster. Thank you.

         

         

        I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
        Best Regards,
        Fen Ling,
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.