DAX Calculated column rank by measure

  • I have a report request to add a parent group to a pivot table that is the rank of the group by the total sales measure, to this effect:

    Total Sales Group   Category Total Sales
    -----------------            --------     -----------
    Over 1 Million          Toys     $2,500,000
                                    Socks   $1,750,000
                                    Shoes   $1,200,000

    Under 1 Millon         Dresses  $  900,000
                                    Hats       $  490,000

    It appears that the "Total Sales Group" has to be a calculated column, not a measure, so that it can be a row group in the Excel Pivot Table.
    "Total Sales" is a complex measure, not just a simple sum, and based on child table data aggregations, it would make for a pretty complex formula for a calculated column.

    What's the best method for accomplishing something like this with SSAS tabular?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply