Forum Discussion

Power_Krille's avatar
Power_Krille
Regular Visitor
3 years ago
Solved

Select a specific value from a table

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. 

FromToValue
051000
6102000
11153000

 

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 ValueAvalue
100021000
 22000
 23000

 


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

Picked Value
 


How can i solve this
Regards
Christian

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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