Rank summarised results...

[Matty]

Hi,

I know I can use SUMMARIZE to create a grouped and summed table using DAX, but how do I then sort/rank the resulting table?

Here's my DAX formula as it stands

Aggregated Table =
SUMMARIZE(
   'Table1,Table1[Column1],
    "Total",
    SUM(Table1[Column2])
)

I was hoping to add a function similar to ORDER BY in SQL to the above, but I can't get anything to work.

Hope someone can help.

Cheers,

Matty

 

[Matty]

Aggregated Table =
CALCULATETABLE (    
    SUMMARIZE(
        'Table1,Table1[Column1],
        "Total",
        SUM(Table1[Column2])
    ),
    Table1[Shop] = "Shop A"
)

Hi Gaz,

Thanks for this, but I need all of the functionality of the first formula (i.e. including the rank).

Can this be done?

Cheers,

Matty

 

[Matty]

Hi Gaz,

Thanks for this, but I need all of the functionality of the first formula (i.e. including the rank).

Can this be done?

Cheers,

Matty

Not to worry - sorted now!

Cheers,

Matty