topic Re: Is there any way to get which column is selected in a table for sorting in DAX Commands and Tips

Is there any way to get which column is selected in a table for sorting

moltra — Sat, 23 Jul 2022 08:34:05 GMT

Say I have a table like below.

Open Job Tables Currently sorted by Job

Name	Date	Job (selected to sort by)	Status
name 10	7/1/22	dax measure	open
Name 2	3/1/22	visual formating	closed

and I would like to create a measure that would return the Table name and which column is selected to sort the table.

I know that I can use SelectedValue to return what is selected in a slicer. Is there a way to find out what column is selected in a table for sorting?

Re: Is there any way to get which column is selected in a table for sorting

tamerj1 — Sat, 23 Jul 2022 09:35:46 GMT

Hi moltra

Nice idea. You may try ISINSCOPE in. SWITCH statement

Re: Is there any way to get which column is selected in a table for sorting

moltra — Thu, 28 Jul 2022 12:20:22 GMT

I tried ISINSCOPE and it does not return anything.