How to get total per day for specific category

[Anonymous]

I need a calculated column to get the total calls per day for a specific campaign. 

I've tried: 

xyz calls = CALCULATE(SUM('Call Stats'[CALLS]), ALLSELECTED('Call Stats'[DATE]),FILTER('T1 Client Stats', 'Call Stats'[CAMPAIGN] = "xyz"))

 and 

xyz calls = CALCULATE(SUM('Call Stats'[CALLS]), ALLEXCEPT('Call Stats','Call Stats'[DATE]),FILTER('Call Stats', 'Call Stats'[CAMPAIGN] = "xyz"))

but both keep giving me the total for all days instead of the total for each day.

Sample Table:

DATE	CAMPAIGN	CALLS
4/1/2023	xyz	4
4/1/2023	xyz	5
4/1/2023	abc	12
4/1/2023	edg	1
4/2/2023	xyz	6
4/2/2023	edg	2

[vicky_ · Accepted solution]

You need to keep the filter on the campaign name, rather than the date filter. I believe you want to change your calc to something like: 

CALCULATE(SUM('Call Stats'[CALLS]), ALLEXCEPT('Call Stats','Call Stats'[CAMPAIGN]))