Select a specific value from a table

[Power_Krille]

Hi, 

I have created a messure from one table and i want to use that output of the messure to get a specific number from another table;

Lets say that my messure shows 2 then i want to use below table to get Value 1000. 

From	To	Value
0	5	1000
6	10	2000
11	15	3000

I have tried with SELECTEDVALUE() and i get this result, it almost works,
"Picked Value = IF([A]>= SELECTEDVALUE('Value Table'[Fr]) && [A]<= SELECTEDVALUE('Value Table'[To]),SELECTEDVALUE('Value Table'[value]))"

Picked Value	A	value
1000	2	1000
	2	2000
	2	3000

But when removing column A and Value column "Picked Value" ends up empty

Picked Value

How can i solve this
Regards
Christian

[Anonymous · Accepted solution]

Hi @Power_Krille ,

SELECTEDVALUE function not suitable to handle the row context that mixed with multiple records. (it will return blank when you use it on aggregate multiple row contexts)

If you want to use these expression without column A, you can try to create a variable table with current category and correspond A value and use them to get corresponding Value from the segmentation table, then you can do aggregate with these results:

Picked Value =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( Table ),
        [Category],
        [A],
        "Result",
            MAXX (
                FILTER (
                    ALLSELECTED ( 'Value Table' ),
                    'Value Table'[Fr] <= currVal
                        && 'Value Table'[To] >= currVal
                ),
                [value]
            )
    )
RETURN
    SUMX ( summary, [Result] )

Regards,

Xiaoxin Sheng