Dynamic sorting for matrix column headers based on Field Parameter

[anshusaketsingh]

Hi Experts 

So I am using a field parameter as column and want it to sort dynamically based on distinct count of order ids. For eg, I want the below table to sort dynamically with Standard Class on left as it has highest order ids , followed by Second Class, First Class and then Same Day.

But it should dynamically change order based on order ids when I switch to Category or any other parameter.

I tried to create a dax to countd distinct ids and rankx to rank the dimensions but it is giving circular error.

Any help will be deeply appreciated.

Added a workbook with case scenerio for reference.

Superstore Reference Workbook.pbix

Sample - Superstore.xlsx

Dataset Looks like-

[lbendlin]

want it to sort dynamically based on distinct count of order ids

That's a great requirement.  Unfortunately columns can only be sorted based on other columns which means the sort order is static.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41