Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

count values with filters

Hi! Please advice! Look I got table with trucks numbers by cityes and deliveryes by dates and truck numbers. How to do the the measure that will give me the constant value (summ of trucks) all the year long?

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Not that much information, looks like a simple measure = Countrows (table) and then you apply your measure with your filters, but it's better if you explain with a little more detail

    • Anonymous's avatar
      Anonymous
      Not applicable

      Dear v-chuncz-msft,

       

      Please give the example of this formula.

       

      Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable

        eugeny, you are requesting a very broad question. We already told you that you can simply CALCULATE the total or COUNTROWS (I wrote you measure=COUNTROWS(table)) but we really can't help you without more detail