Forum Discussion
Sorting on Total Column in Matrix
Hi Srikarnandan7,
Step1: Added ID column to Values and changed that to Count
Step2: Created new column 'Total' for sorting with below expression
Total= COUNT('test'[ID])
Step3: I applied sorting on 'Total' column using 'Sort by Column', didn't work.
Please suggest me, am I missing something?
I'm not sure I understand step2. What do you mean about creating new column 'Total'? Based on my understanding, a Grand Total column should be added to the Matrix without any action. Could you be more precisely with it? :smileyhappy:
In addition, it could be better if you could share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Regards
Hi Srikarnandan7,
Step1: Added ID column to Values and changed that to Count
Step2: Created new column 'Total' for sorting with below expression
Total= COUNT('test'[ID])
Step3: I applied sorting on 'Total' column using 'Sort by Column', didn't work.
Please suggest me, am I missing something?
I'm not sure I understand step2. What do you mean about creating new column 'Total'? Based on my understanding, a Grand Total column should be added to the Matrix without any action. Could you be more precisely with it? :smileyhappy:
In addition, it could be better if you could share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Regards
Hi v-ljerr-msft
I got this now. I just clicked on 'Total' column for sorting. Thanks for the help.