February 4, 2014 at 8:55 am
I think I know the answer but would welcome any thoughts. I'm using the Tabular BISM with Excel Pivot as the front end.
I want to show:
Top 100 customers... $10000
Next 100 customers.. $70000
Etc...
I have it working fine using RankX in a calculated column. Problem is calculated columns are only calculated when the cube is processed. If I want to filter the report say by product group, date, or whatever the rankings don't dynamically change like you'd want as filters are applied.
Now.. I can also use RankX as a measure which does update as filters are applied. Problem here is I can't use a measure on columns or rows in the pivot table, so I can't group by the "Top 100" measure for instance.
I did see a post where someone seems to have solved this through Excel macros by dynamically creating a new DAX query and updating his data connection properties each time a slicer is clicked but I'd rather do it through some standard tabular DAX methods only.
Thoughts?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply