Forum Discussion

anoop_ellickal's avatar
anoop_ellickal
New Member
8 years ago
Solved

Count the occurrence of values (Text) in a column

I have a column like this 

 

mango

orange

mango

grape

orange

mango

orange

mango

apple

 

need an out put like 

mange 4

orange  3

Grape  1

Apple 1

Need Help

3 Replies

  • quentin_vigne's avatar
    quentin_vigne
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi anoop_ellickal

     

    Add a multiple card box with your fruit column.

    It will display every distinct fruit name

     

    Then create a new measure : 

     

    Mesure_CountGlobal = COUNTROWS(YourTable[Fruit])

    Add this measure to your multiple card box.

    And now you have a count for each value !

     

    - Quentin

    • anoop_ellickal's avatar
      anoop_ellickal
      New Member
      8 years ago

      Thanks you for your support 

      I can only add table not the fields 

       

      COUNTROWS(YourTable)

       this is the problem I am facing