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...
MattAllington
Community Champion
Community ChampionInteresting. 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.
MattAllington wrote:You can’t refer to a slicer in a dax formula for a calculated table.
Hi MattAllington,
Why can't refer to a slicer for a calculated table? Is this a bug of Power BI?
