In my dashboard, there is four dimensions Country, Region, Category and City. Now I want to return rank for lowest selected dimension against SALES as measure. What do I mean by lowest dimension selected? let’s say:
Scenario -1, Country USA is selected and values of all lower dimensions(in hierarchy) are not selected then lowest selected dimension is Country and rank will represent position among the countries
Scenario -2, Category B is selected and values of dimension City(dimension lower than Category) is not selected then lowest selected dimension is Category and rank will represent among the Categories.