Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
95 | |
88 | |
70 |
User | Count |
---|---|
165 | |
131 | |
129 | |
102 | |
98 |