Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I am trying to make this code work but facing some issues. Here Parameter X and Y are field parameters which i am using as a selection criteria. Now, if i remove the variables Value_Parameter & Measure_Parameter and just put the column name in the VALUES and TotalMarks, it works fine.
Not sure why i am unable to use field parameters with this code.
TopN_Values =
VAR Value_Parameter = SelectedValue('Parameter X'[Parameter X Fields])
VAR Measure_Parameter = SelectedValue('Parameter Y'[Parameter Y Fields])
VAR Top3Names =
TOPN(3,
ADDCOLUMNS(
VALUES(Value_Parameter ),
"TotalMarks", Measure_Parameter
),
[TotalMarks], DESC
)
RETURN
CONCATENATEX(Top3Names, Value_Parameter , ", ")
Thanks @Anonymous for explaining this. How do i change it from scalar to reference? Is there anything that i can do to achieve this?
Hi @ERAHUMO ,
You can try this:
TopN_Values =
VAR Value_Parameter = SELECTEDVALUE('Parameter X'[Parameter X Fields])
VAR Measure_Parameter = SELECTEDVALUE('Parameter Y'[Parameter Y Fields])
VAR Top3Names =
TOPN(
3,
ADDCOLUMNS(
VALUES(
SWITCH(
TRUE(),
Value_Parameter = "ColumnName1", 'Table'[ColumnName1],
Value_Parameter = "ColumnName2", 'Table'[ColumnName2],
'Table'[DefaultColumn] // Default case
)
),
"TotalMarks",
SWITCH(
TRUE(),
Measure_Parameter = "MeasureName1", [Measure1],
Measure_Parameter = "MeasureName2", [Measure2],
[DefaultMeasure]
)
),
[TotalMarks], DESC
)
RETURN
CONCATENATEX(Top3Names, [Value_Column], ", ")
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ERAHUMO ,
From your description, it sounds like you're trying to dynamically select columns based on user selection and then perform operations like TOPN
and CONCATENATEX
on these dynamically selected columns. The issue arises because SelectedValue
returns a scalar value (the name of the column as text), not a column reference that DAX functions like VALUES
and ADDCOLUMNS
expect.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.