Forum Discussion
jlarques
2 years agoHelper V
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...
- 2 years ago
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 - 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
vicky_
2 years agoSuper User
You can create a DAX column (or measure) with:
Count of Country Code = CALCULATE(COUNT(Table[Country Code]), ALLEXCEPT(Table, Table[Country Code]))