Forum Discussion
Johnny123
7 years agoNew Member
Calculation depending on multiple filter selection
i try to calculate the count of entries within a column depending on the (multiple) filter option. In my table I have 3 different columns: 1. Team 2. Cup: This should be my filter with ...
- 7 years ago
Result = CALCULATE(COUNTROWS(Table1), FILTER(ALLSELECTED(Table1), Table1[Point] <> BLANK()))
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yuta-msft
Community Support
7 years ago
Result = CALCULATE(COUNTROWS(Table1), FILTER(ALLSELECTED(Table1), Table1[Point] <> BLANK()))
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.