Forum Discussion
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: Date Score Client Type 1/1/2023 09:00:AM 100 A Onl...
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")))
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")))