Categorizing fields in multiple buckets

Hi  brizy ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Count =
var _count=
COUNTX(FILTER(ALL('Table'),YEAR('Table'[Date])=YEAR(EARLIER('Table'[Date]))&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))&&'Table'[statuses]=EARLIER('Table'[statuses])),[statuses])
var _max=CALCULATE(MIN('Table'[Date]),FILTER(ALL('Table'),YEAR(EARLIER('Table'[Date]))&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))&&'Table'[statuses]=EARLIER('Table'[statuses])))
return
IF(
    'Table'[Date]=_max,_count,0)

2. Create calculated table.

True =
var _summ1=
SUMMARIZE('Table',
'Table'[Date],
"statuses","ActualAttendance",
"Count",
SUMX(FILTER(ALL('Table'),YEAR('Table'[Date])=YEAR(EARLIER('Table'[Date]))&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))&&'Table'[statuses] in { "Attended","Non RSVP"}),[Count]))

var _summ11=
UNION('Table',_summ1)

var _summ2=
SUMMARIZE('Table',
'Table'[Date],
"statuses","RSVPAttended",
"Count",
SUMX(FILTER(ALL('Table'),YEAR('Table'[Date])=YEAR(EARLIER('Table'[Date]))&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))&&'Table'[statuses] ="Attended"),[Count]))

var _summ22=
UNION(_summ11,_summ2)

var _summ3=
SUMMARIZE('Table',
'Table'[Date],
"statuses","NonRSVPAttended",
"Count",
SUMX(FILTER(ALL('Table'),YEAR('Table'[Date])=YEAR(EARLIER('Table'[Date]))&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))&&'Table'[statuses] ="Non RSVP"),[Count]))

var _summ33=
UNION(_summ22,_summ3)

var _summ4=
SUMMARIZE('Table',
'Table'[Date],
"statuses","TotalRSVP",
"Count",
SUMX(FILTER(ALL('Table'),YEAR('Table'[Date])=YEAR(EARLIER('Table'[Date]))&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))&&'Table'[statuses] in { "Attended","RSVP"}),[Count]))

var _summ44=
UNION( _summ33,_summ4)

var _summ5=
SUMMARIZE('Table',
'Table'[Date],
"statuses","Did not attend",
"Count",
SUMX(FILTER(ALL('Table'),YEAR('Table'[Date])=YEAR(EARLIER('Table'[Date]))&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))&&'Table'[statuses] ="RSVP"),[Count]))

var _summ55=
UNION(_summ44,_summ5)

return
_summ55

Create computed column in True table

COUNT_ALL =
IF(
    'True'[Date]=
CALCULATE(MIN('True'[Date]),FILTER(ALL('True'),YEAR('True'[Date])= YEAR(EARLIER('True'[Date]))&&MONTH('True'[Date])=MONTH(EARLIER('True'[Date]))&&'True'[statuses]=EARLIER('True'[statuses]))),
[Count],BLANK())

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly