Count Measure based on all filters or columns except one

[DeanB]

So I've got a table looking something like this that lists communications that have been sent and via what method

Customer ID	Message	Delivery Method	Sent Time
1	Welcome	Email	AM
1	Welcome	Letter	AM
2	Welcome	Email	PM
3	Congrats	Letter	AM
3	Congrats	Email	PM
3	Congrats	Letter	AM

What I want is to put it into a table like this in a Power BI report

Customer ID	Message	Delivery Method	Count Sent	Count Sent any Delivery Method
1	Welcome	Email	1	2
1	Welcome	Letter	1	2
2	Welcome	Email	1	1
3	Congrats	Letter	2	3
3	Congrats	Email	1	3

Now the first 4 columns are easy, but what I need is a measure for the last column. I need it as a measure as I would like it to work with filters. For example if I filtered to just PM, then the value should update.

The difficulty I'm having is that it's easy to count all rows. I can even count all rows that match just the customer ID and Message, but what I can't do is count all rows that match everything (those two columns plus any applied filters) regardless of the delivery method column.

Any help would be appreciated, thanks.

Edit: can't get the table to display correectly. It looks correct when I edit the post and if I try and change the column width I get an error saying invalid html

[johnt75 · Accepted solution]

You can create a measure like

Count sent any delivery method =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALLEXCEPT ( 'Table', 'Table'[Delivery method] )
)