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.
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

For counting 2, use following (Replace Previous Step with your previous step)

 

= List.Count(List.FindText(#"Previous Step"[Vekt utenfor norm],"2"))

 

For any other value say 5, replace 2 with 5.