Forum Discussion
Filter and Count Values in a column
Hi Experts
I cannot see my error - want to Count the occurence in a column the number of time we get apples and banana - based on Filter
CALCULATE(
COUNT('STG Fact_To_Do'[Task_Results]),
FILTER('STG Fact_To_Do','STG Fact_To_Do'[Task_Results] ="Apples" && "Banana"))
Anonymous , You want like ?
CALCULATE(
COUNT('STG Fact_To_Do'[Task_Results]),
FILTER('STG Fact_To_Do','STG Fact_To_Do'[Task_Results] in {"Apples", "Banana"}))
2 Replies
- amitchandak
Super User
Anonymous , You want like ?
CALCULATE(
COUNT('STG Fact_To_Do'[Task_Results]),
FILTER('STG Fact_To_Do','STG Fact_To_Do'[Task_Results] in {"Apples", "Banana"}))