Calculate sum with multiply filter

[cvarvar]

Hi all,

Here is an example of data

Month	Segment	Type	Customers
02/2022	FIX	AC	10
02/2022	FIX	NOR	15
02/2022	MOB	AC	5
02/2022	MOB	NOR	8
02/2022	FMC_F	AC	3
02/2022	FMC_F	NOR	5
02/2022	FMC_M	AC	1
02/2022	FMC_M	NOR	2
03/2022	FIX	AC	15
03/2022	FIX	NOR	15
03/2022	MOB	AC	10
03/2022	MOB	NOR	8
03/2022	FMC_F	AC	5
03/2022	FMC_F	NOR	5
03/2022	FMC_M	AC	1
03/2022	FMC_M	NOR	3
04/2022	FIX	AC	5
04/2022	FIX	NOR	5
04/2022	MOB	AC	6
04/2022	MOB	NOR	7
04/2022	FMC_F	AC	5
04/2022	FMC_F	NOR	3
04/2022	FMC_M	AC	1
04/2022	FMC_M	NOR	1

and i want to make calculation based on Segment and Month. So to like this:

Month	Segment	Type	Customers	Total_Month_Segm
02/2022	FIX	AC	10	25
02/2022	FIX	NOR	15	25
02/2022	MOB	AC	5	13
02/2022	MOB	NOR	8	13
02/2022	FMC_F	AC	3	8
02/2022	FMC_F	NOR	5	8
02/2022	FMC_M	AC	1	3
02/2022	FMC_M	NOR	2	3
03/2022	FIX	AC	15	30
03/2022	FIX	NOR	15	30
03/2022	MOB	AC	10	18
03/2022	MOB	NOR	8	18
03/2022	FMC_F	AC	5	10
03/2022	FMC_F	NOR	5	10
03/2022	FMC_M	AC	1	4
03/2022	FMC_M	NOR	3	4
04/2022	FIX	AC	5	10
04/2022	FIX	NOR	5	10
04/2022	MOB	AC	6	13
04/2022	MOB	NOR	7	13
04/2022	FMC_F	AC	5	8
04/2022	FMC_F	NOR	3	8
04/2022	FMC_M	AC	1	2
04/2022	FMC_M	NOR	1	2

I tried a lot of things, like double filter, but the calculation was only per month, not per month and per segment. Any ideas. 

Thank you.

[cvarvar · Accepted solution]

After a lot of tries I use this function:

Cust_per_Seg_Month = CALCULATE(SUM(Churn[Customers]), ALLEXCEPT(Churn,Churn[SEGMENT],Churn[MONTH]))

and it works.

[Anonymous]

Hi @cvarvar ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours.  Thank you.

Best Regards