Sumx- Per Week

[AllanBerces]

Hi good day,

Pls need assistance on how can i get the sum per week base from Phase and Trade.

Thank you

[Ashish_Mathur]

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?

[AllanBerces · Accepted solution]

Hi @Ashish_Mathur @sivarajan21 @mickey64 thank you to all your reply, i got the solution on my query.

Thank you

[Anonymous]

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.

[sivarajan21]

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!

[AllanBerces]

BTW i required it as Calculated Column

[mickey64]

For your reference.

[AllanBerces]

Hi @mickey64 Thank you for the reply, but i need it as Calculated Column.

[mickey64]

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]))