Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count Measure based on all filters or columns except one

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 ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    You can create a measure like

    Count sent any delivery method =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALLEXCEPT ( 'Table', 'Table'[Delivery method] )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You can create a measure like

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