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

Hi MattAllington,
Thank you for your reply.
There is a mistake in my previous description. The real issue is that the SELECTEDVALUE can't work in IF function, the return value of it always is the default.


My SELECTEDVALUE formula is as following: 

        tempVal = SELECTEDVALUE(t_stream_type[type], "Cloud")


And the IF formula is as following:
        multiplier = IF([tempVal] ="Cloud", 1, 2)

And the slicer 'Stream' has three options as the following picture:


The issue is no mater what I selected in the slicer, the value of multiplier always equal to '1'.
Could you help me ?

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

    How does the column t_stream_type[type] relate to the slicers in your image. It is not clear. 

    • Hawk_Wang's avatar
      Hawk_Wang
      Regular Visitor
      7 years ago
      MattAllington wrote:

      How does the column t_stream_type[type] relate to the slicers in your image. It is not clear. 

      Just create a new slicer, and the the 'type' field of t_stream_type to the slicer.