Using field parameters in dax measure to calculate topn

[ERAHUMO]

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 , ", ")

[ERAHUMO]

Thanks @Anonymous for explaining this. How do i change it from scalar to reference? Is there anything that i can do to achieve this?

[Anonymous]

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.

[Anonymous]

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.