How to call a column from calculated var table

[bml123]

HI,

I am using a calculated var table in a measure and need to call a column from a calculated var table to do some calculation.

How do I do that?

[Anonymous · Accepted solution]

Hi @bml123 ,

You will need to define a name for this calculated column.

For example:

var table = selectedcolumns('table',"columnname",[column])
or

var table = addcolumns('table',"columnname",[column])

or

var table = SUMMARIZE ('table', [groupBy_columnName], "columnname", [column])

In above cases you could directly call the columnname.

Best Regards,

Jay

[amitchandak]

@bml123 , Not very clear, refer to example

measure  =

var _tab = summarize(Table, Table[Employee], "_1", [M1])

return

Countx(Values(_tab), [Employee])