refer to columns from string variable

[Analitika]

 How to refer to columns from string variable?

Measure=
var strVar = "Table1[Column1]"
RETURN
CALCULATE(SUM(strVar))

[jbauer22]

I need this too.

[Icey · Accepted solution]

Hi @Analitika ,

Try this:

1. Enter data to create a ColumnName table.

2. Create a Measure like so:

Measure =
VAR t1 =
    ADDCOLUMNS (
        SELECTCOLUMNS ( 'Table', "ColumnValue", 'Table'[Column1] ),
        "ColumnName", "Column1"
    )
VAR t2 =
    ADDCOLUMNS (
        SELECTCOLUMNS ( 'Table', "ColumnValue", 'Table'[Column2] ),
        "ColumnName", "Column2"
    )
VAR t3 =
    ADDCOLUMNS (
        SELECTCOLUMNS ( 'Table', "ColumnValue", 'Table'[Column3] ),
        "ColumnName", "Column3"
    )
VAR t =
    UNION ( t1, t2, t3 )
VAR SelectedColum =
    SELECTEDVALUE ( ColumnName[ColumnName] )
RETURN
    SUMX ( FILTER ( t, [ColumnName] = SelectedColum ), [ColumnValue] )

Then, you will get this:

BTW, .pbix file attached.

Best Regards,

Icey

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

[amitchandak]

@Analitika , Not tested. But try like

Measure=
var strVar = Table1[Column1]
RETURN
CALCULATE(SUM(strVar))

[Analitika]

i need from string only as i need dinamic change it