Forum Discussion

Dougers1's avatar
Dougers1
Frequent Visitor
2 years ago
Solved

need help with count formula

Hi

 

i am trying to create a card  that will show me the amount of times  the work substantive Filled appears in column, i  added this measure 

Substative Filled = COUNT('Interpreting 2023'[Substantive Filled ])
 
but it bring me back a total of 880 for april when it should be 320
 
 
any help 
 
please
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    2 years ago

    Hi,

     

    If you're looking to count the number of times the word Substantive Filled appears in a column, try the below:

     

    Substative Filled = CALCULATE(COUNT('Table name'[Column name]),'Table name'[Column name]= "Substantive Filled")

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    2 years ago

    Hi,

     

    If you're looking to count the number of times the word Substantive Filled appears in a column, try the below:

     

    Substative Filled = CALCULATE(COUNT('Table name'[Column name]),'Table name'[Column name]= "Substantive Filled")

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍