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.
Querynalyst's avatar
Querynalyst
Frequent Visitor
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.
Crangel's avatar
Crangel
Frequent Visitor
3 years ago

I tried applying this calc to my issue, but it didn't work, can you tell me what i did wrong? Or maybe I'm using it wrong. I have a survey table (Form1) with column [Language]. I'm trying to create a visual table that contains a column for where the survey originated [Center], and then  column English with the total of English language surveys submitted for that center, and again with a column for Spanish. I thought i could just create a measure to count the occurange of English and add that to my table but the calc below does not work. The rest of the calc is valid, but it doesnt recognize "english". Maybe if I transform it to a numeric value? Thanks so much for your help!

 

English = CALCULATE(COUNT(Form1[Language]),Form1[Language]="English")