Forum Discussion

KPMEE's avatar
KPMEE
Frequent Visitor
2 years ago
Solved

New Column Filtered

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:

DateScoreClientType
1/1/2023 09:00:AM100AOnline
1/1/2023 09:01:AM90BOnline
1/1/2023 09:02:AM95CEmail

 

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

Need Help
  • KPMEE's avatar
    KPMEE
    2 years ago

    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")))

1 Reply

  • KPMEE's avatar
    KPMEE
    Frequent Visitor
    2 years ago

    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")))