Using a column as a variable in a calculated column formula

[Anonymous]

Hi all,

I'm running into trouble trying to use SELECTEDVALUE on a column from a table variable.

See code below from calculated column, inside "Current Table"

Department Selected = 

//Other defined variables here...

var temptable =
SELECTCOLUMNS(
    FILTER(
        'Table1',
        'Table1'[CustomerID] = 'Current Table'[CustomerID]
        && 'Table1'[Start Date] <= variable1
        && 'Table1'[End Date] > variable2
        && 'Table1'[Urgency] = variable3
    ),
    "Department",'Table1'[Department]
)

return
SELECTEDVALUE('temptable'[Department], "multiple departments")

My code of course fails on the return, as you can't seem to reference a column of a variable table in selectedvalue.

Is there an alterative way I can accomplish this?

I don't want to use CALCULATE, as it takes absolutely ages and I'm trying to find a workaround. I also need it to be a calculated column, so can't use a measure.

Thanks in advance!

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490