Forum Discussion
Counting automatically rows in filtered table
Hi together,
how can I count each row in a filtered table automaticaly and set the numbers from 1 to n in cloumn "Counter" as on the screenshot below?
2 Replies
Anonymous look at RANKX function
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
parry2k thanks for your hint 😊 I tried to use the RANKX formula in my usecase but the values (numbers) that I got are not from the filtered table - they are from the whole table. How can I specify this formula into my filtered table?
