Filter values without using any aggregate function?

[Ronnie7]

Hello,

I was wondering whether it's possible to filter out certain values from a column without using any aggregate function. Here's what i currently have:

Incoming Messages =
CALCULATE (
COUNTA( ps_IncomeMessages[MessageType]),
ALL ( ps_IncomeMessages[MessageType] ),
'ps_IncomeMessages[MessageType] = ("01 - Text Message")
|| ps_IncomeMessages[MessageType] = ("02 - MMS Message")
)

I basically want the new column, "Incoming Messages" (in the data model), two include only these 2 values (out of 6 possible values) without counting the rows or summarize, etc'. 

Thanks!

[Greg_Deckler · Accepted solution]

Remove your ALL clause.