refer to columns from string variable

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.