Grouping Data

[powerbi_lost]

I have this visual table and I want it to be first grouped autoamtically by branch and then by Highest to lowest turn around days.

[Anonymous · Accepted solution]

Hi @powerbi_lost ,

Here's my solution.

Create a calculated column.

Rank = RANKX('Table',[Turnaround days]+RANKX('Table',[Branch],,DESC,Dense)*100,,DESC,Dense)

Then you could add the rank column into the table visual, sort asc.

Best Regards,

Stephen Tao

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

[powerbi_lost]

Thank you! It worked 🙂 

[Tahreem24]

@powerbi_lost Try this new Table DAX:

Table = SUMMARIZE(BranchTable,BranchTable[Branch],"TurnAround Days",SUM(BranchTable[Turnaround Days]))

[Anonymous]

Hey PowerBI_lost,

I think you should use a matrix visual instead of a table visual. Then you are able to group. Then you can sort on Turnaround days.

I think this will give you the result you are searching for.