New Column Filtered

[KPMEE]

Hi,

I'm looking for something that most likely isn't that hard to do, but I keep messing it up.

I have a table with the following:

Date	Score	Client	Type
1/1/2023 09:00:AM	100	A	Online
1/1/2023 09:01:AM	90	B	Online
1/1/2023 09:02:AM	95	C	Email

In order to display the scores from all three clients seperately in a table/matrix, I want to create a new column for each client, that is filtered by the Client value, and Type value (which are text values).

How do I go about this?

Thank you in advance

[KPMEE · Accepted solution]

Solved it, for those who need the same. Add a measure, not column:

Score Client A = CALCULATE(AVERAGE(table[Score]), FILTER(table, AND(table[Client] = "A", table[Type] = "Online")))