Forum Discussion

maserr's avatar
maserr
Helper IV
6 years ago

Save value from a table

Hi there,   I am feeling pretty lost with DAX. I have a doubt I would know how to solve if the cell was a number, as I would store in a measure the value using CALCULATE(SUM(Value), Filter), but I ...
nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

maserr  DAX measures are dynamic. We cannot store the value based on the previous selection.

 

If you select Value 3 = 'Z' below measure will return 'X'. But the moment you select another value or deselect the Value 3, result will change.

 

Val1 = SELECTEDVALUE(MyTable[Value1])



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

 

    • kentyler's avatar
      kentyler
      Solution Sage
      6 years ago

      So, you wish to match a given value against a set of "target" values, but your problem is that the target values are strings instead of numbers... can you give us an example of the actual target values you want to use. 

      I think you will have to list all of your target strings. You probably not be able to use anything like, greater than or less than with strings. So your table of targets would be larger, but would work just by matching, using LOOKUPVALUE(), for example.