number row in slice

[bradley_davis1]

Is it possible to number the rows in a filtered slice starting from 1?

[SkrOYC]

Good question, but I don't think so.

Maybe @Steve has more info about it

[bradley_davis1]

I am hoping that by doing this I can create a simple page numbering on my pdf output. Basically my rows never exceeds 1 page so I have put a page break in and if I can get it to number the rows then a can use this as the page number 🙂

If that makes any sense

[Steve]

Not possible.

[Kirk_Masden]

Isn't it true that this would work, though it might not be very efficient?

COUNT(SELECT(MyTable[KeyColumn], [_RowNumber] <= [_THISROW].[_RowNumber]))

[dbaum]

FWIW: I have indeed used that technique to number rows using an "Index" (virtual) column, and encountered performance issues when it involved several thousand rows. Potentially, this column wasn't an absolute problem per se, but it indeed was enough to tip an automation's execution time over the timeout limit. Consider limiting its use (e.g., via CONTEXT) to where you need it (e.g., for display in a specific view).

[Kirk_Masden]

Actually, @dbaum , I think I got the expression from you.  Thanks! 🙂 And sorry for not acknowledging that in my post. 😞

[dbaum]

While I don't recall that, it's possible. And, attribution is not necessary, but your comment is a great reminder that we all learn a lot from each other in this community.

[Steve]

---

@Kirk_Masden wrote:

Isn't it true that this would work, though it might not be very efficient?

---

True indeed!