Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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]), FILT...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

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

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks