Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
How to refer to columns from string variable?
Measure=
var strVar = "Table1[Column1]"
RETURN
CALCULATE(SUM(strVar))
Solved! Go to 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.
I need this too.
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.
@Analitika , Not tested. But try like
Measure=
var strVar = Table1[Column1]
RETURN
CALCULATE(SUM(strVar))
i need from string only as i need dinamic change it
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |