SELECTEDVALUES as existing column names

[Anonymous]

Hi im new to power BI, and i was wondering if i am able to use the SELECTEDVALUE value to call out the column of the table with the same name as the value given? In a way, performing this action : 

CALCULATE(SUM(Graph[User Chosen]), Graph[SnapMonth] = [User Selection])

User Chosen = SELECTEDVALUE('Full Snap Months'[SnapMonth])     #Full Snap Months is referencing table 
Graph is the table where all the data and measures are located in.

Pleaseee help 🙂

 

[v-xiaotang · Accepted solution]

Hi @Anonymous 

do you mean you want to use [User Chosen] as selected column name? if yes, actually  Graph[User Chosen]  this is not supported in desktop.

you can take a workaround to solve the question. you can try IF() or Switch() like bellow.

Measure = 
var _a= SELECTEDVALUE('filter'[filter])
return IF(_a="Column1", SUM('Table'[Column1]),IF(_a="Column2",SUM('Table'[Column2])))

hope it helps.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Understood! So there really isnt any way to automate this measure in desktop?

[v-xiaotang]

Hi @Anonymous 

yes, that's really impossible. in Dax expression, the format is fixed, 'Table'[Column].  it can not be dynamic.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , seem like [User Chosen] is a measure , if so

CALCULATE(SUMX(Graph,[User Chosen]), Graph[SnapMonth] = [User Selection])

or

CALCULATE(Countx(Graph,[User Chosen]), Graph[SnapMonth] = [User Selection])