I've made a table like this. I want to add a third column that contain counts of the second column (In this case, from top to bottom that would be: 1,6,6,6,6,6,6,11,11,11,11,11,11,11,11,11,11,11). What expression can I use to accomplish this?
This is along the lines of what I want, but it produces a column of all 1's
As for the other answers, I wish to do this all in a single measure if possible. In my actual app, the '100' is not fixed. It will be many different values for different chart objects so solving this with a new dimension in the data model is not a viable option.