Forum Discussion

jlarques's avatar
jlarques
Helper V
2 years ago
Solved

Count rows with same code

Dear community, I have a fact table with same country code in many rows, and I want to create a new calculated column that: If country code appears one time, new column will have 0 If country cod...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    jlarques 

    you can try to create an index column in pq

     

    then use DAX to create a column

     

    Column = CALCULATE(count('Table'[country]),FILTER('Table','Table'[country]=EARLIER('Table'[country])&&'Table'[Index]<=EARLIER('Table'[Index])))
     
     
    if you have a datetime column, you can use that instead of the index column
  • jlarques's avatar
    jlarques
    2 years ago

    Hi ryan_mayu ,

     

    thanks for your answer. I tested and it works! It's amazing!. I would never have achieved it and I am extremely grateful that knowledge can be shared in this community. Thank you very much for your help and Anonymous  and vicky_ who have also wanted to help me with this, for me, difficult problem.

     

    Thanks again to this community.

     

    José Luis 

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

jlarques 

you can try to create an index column in pq

 

then use DAX to create a column

 

Column = CALCULATE(count('Table'[country]),FILTER('Table','Table'[country]=EARLIER('Table'[country])&&'Table'[Index]<=EARLIER('Table'[Index])))
 
 
if you have a datetime column, you can use that instead of the index column
  • jlarques's avatar
    jlarques
    Helper V
    2 years ago

    Hi ryan_mayu ,

     

    thanks for your answer. I tested and it works! It's amazing!. I would never have achieved it and I am extremely grateful that knowledge can be shared in this community. Thank you very much for your help and Anonymous  and vicky_ who have also wanted to help me with this, for me, difficult problem.

     

    Thanks again to this community.

     

    José Luis 

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      2 years ago

      you are welcome