June 2016 Entries

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.So one way to make ......

Posted On Saturday, June 4, 2016 3:38 PM | Comments (2)