Forum Discussion

Hawk_Wang's avatar
Hawk_Wang
Regular Visitor
7 years ago

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...
Need Help
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
7 years ago

No it is not a bug. Tables and columns are considers static parts of he data model and do not update based on slicer interaction. 

Hawk_Wang's avatar
Hawk_Wang
Regular Visitor
7 years ago

And now I use the same formula as  multiplier to create a new measure multiplier2 in a normal data table( not calculated table) , the formula is as following:
multipler2 = IF([tempVal] = "Cloud", 1, 2)

 

then multiper2 works well. It's why?

 

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    7 years ago

    There is not enough information to help you here. You don’t say which table is the calculated table, if the column in the slicer is in that calculated table or another table. If any of these tables are joined and if so which Direction the relationships are etc. All this Information is relevant.