Sort the dynamic values in a text box

Hi Anonymous ,

To sort the dynamic values that are shown in the text box, you can use the SORT function to sort the list of values returned by the CONCATENATEX function. Here is an example of how you can modify your measure to achieve this:

Week Card : =
VAR _countrs =
    COUNTROWS(VALUES('Fiscal_Cal'[Week]))
var _countsall =
    CALCULATE(
            COUNTROWS(VALUES('Fiscal_Cal'[Week])), REMOVEFILTERS('Fiscal_Cal')
    )
    return
    if( _countrows = _countsall, "All",
    CALCULATE(
        CONCATENATEX(
            SORT(DISTINCT('Fiscal_Cal'[Week]), 'Fiscal_Cal'[Week], ASC),
            'Fiscal_Cal'[Week],
            ", "
        )
    ))

The SORT function takes in a table as the first argument, and then a list of columns to sort by as subsequent arguments. In this case, we are sorting the list of distinct weeks in ascending order. The ASC argument specifies that the sort order should be ascending. If you want to sort the values in descending order, you can use the DESC argument instead.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.