Forum Discussion
SELECTEDVALUE doesn't work in a measure table
I encounter a issue that when I use the SELECTEDVALUE function in a normal data table, it works fine.
But when I use the SELECTEDVALUE function in a table which was created by DAX formula, it can't work anymore.
It's why? Can anyone help me ?
11 Replies
- MattAllington
Community Champion
Interesting. Are you trying to use a calculated column? If so, you shouldn’t need SELECTEDVALUE if you are referring to a row in the table itself.
Yes, it's quite interesting, and you can have a try. I don't know how to share my pbix file, or I can share it to you.
In the new table created by DAX formula, all the columns are caclulated.
The SELECTEDVALUE is necessary, the value is from a slicer of which the options are defined by myself. I must use the slicer to deal with different cases.- MattAllington
You can’t refer to a slicer in a dax formula for a calculated table.
v-chuncz-msftCommunity Support
