How to refer to virtual table column in a meaure

Hi,
I have been trying to use a column created in summarize in a meaure but get an error, this is not the same problem but
illustrates better what the problem isl
;

Please Login or Register  to view this content.

This returns a table with new column "N" , but the below returns an error, VAUES returns table countrows counts rows of table
What's the problem?

Please Login or Register  to view this content.

Richard

Fair enough but add columns does not seem to work ether ,

example

Please Login or Register  to view this content.

Richard.

Sorry still can't get this to work, this started when I wanted to use a virtual column in TOPN, i have since found a way to get the result I wanted and do
have a question regarding that.

but i can't get this to work work with the VALUES,

Please Login or Register  to view this content.

Which I would have thought would bring back a one column table, I have tried with filter and yes I did just have to put the [N] .
Am missing something ? that's rhetorical you can keep thoughts to yourself.

Richard.

Thanks, I can stop trying, I don't know if you saw my later post re SUMMERIZE, but that is how this started,
I wanted to use VALUES on the virtual summerised topn table,
so I could get a distinct concatenation,

Sought of ;

Please Login or Register  to view this content.

This did not work either.

RD