DAX - Creating a measure for Top 5 and Others
Often when you have a requirement to show a measure for the TopN of a given attribute the users will want to see the subtotal of all the other items.
With multi-dimensional cubes and MDX you can create calculated members in a dimension. But you can’t do this in a tabular model using DAX . You could create a calculated column, but then your TopN would be fixed and could not respond dynamically to changes in filters as calculated columns are calculated and stored at processing time.