Filter and Count Values in a column

[Anonymous]

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

[amitchandak · Accepted solution]

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

[Anonymous]

Thanks