topic How can i assign a value from selectedvalue(column) function into custom column in DAX Commands and Tips

How can i assign a value from selectedvalue(column) function into custom column

sb48846 — Tue, 21 Feb 2023 09:55:38 GMT

Hi Team,

I have created a measure to get the value of month from the selcted filter by using SELECTEDVALUE(table column) function, however i need same value to be assigned to a custom column for each row in a table.

Please suggest me how to get the value into custom column by using SELECTEDVALUE function.

Thanks,

Suman.

Re: How can i assign a value from selectedvalue(column) function into custom column

FreemanZ — Tue, 21 Feb 2023 10:12:24 GMT

hi sb48846

what do you mean by custom column?

Re: How can i assign a value from selectedvalue(column) function into custom column

sb48846 — Tue, 21 Feb 2023 10:21:46 GMT

Hi FreemanZ ,

I mean i have crated

first mesure with following code in one table as below and it displays slected value from filter for each row.

SelectedMonth_M = SELECTEDVALUE('Table Calender'[Month])

Created a new column in same table as below but it does not display any value for each row.

SelectedMonth = SELECTEDVALUE('Table Calender'[Month]).

Please see below screenshot.

Thanks,

Suman.