Forum Discussion
maserr
Helper IV
Helper IVSave 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 ...
maserrHelper IV
Helper IVI think I have not explained myself enough. I would want to achieve which is proposing the accepted solution from this post but with varchar.
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Measures-with-KPI/m-p/1078163#M15168
Thanks
kentyler
Solution Sage
Solution SageSo, 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.