Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count rows containing value

Hi,    I'm trying to count the rows containing specific values.  I've tried this:  Table.FindText(PQPFocus[Vekt utenfor norm],2)  ... but I'm getting a cyclic error.    My column [Vekt utenfor...
Need Help
Tips and Tricks
  • Querynalyst's avatar
    Querynalyst
    4 years ago

    Hello,

     

    I would suggest you to use DAX instead of Power Query for your need.

     

    Example:

    NumberOfTwo = CALCULATE(
                COUNT(PQPFocus[Vekt utenfor norm]),
                    PQPFocus[Vekt utenfor norm] = 2
                        )

     

    Same thing for 5 etc.
     
    I hope this will answer your question.
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I used countrows, but I need it to give me the number in each row, not just mark the numbers with 1...