Hi,
I have two tables: FactSales and DimProduct.
I have created a table using the following:
Where [Sales] is a measure already used elsewhere and references the FactSales table.
I now want to add a rank column (descending) to the above table based on [Sales]. Can I do the ranking as part of the same formula, or do I need to create a separate calculated column once the table's created?
Cheers,
Matty
I have two tables: FactSales and DimProduct.
I have created a table using the following:
Code:
Summary =SUMMARIZECOLUMNS ( DimProduct[Product], "Total Sales", [Sales] )
Where [Sales] is a measure already used elsewhere and references the FactSales table.
I now want to add a rank column (descending) to the above table based on [Sales]. Can I do the ranking as part of the same formula, or do I need to create a separate calculated column once the table's created?
Cheers,
Matty