How to check if the values filtered in one column covers all rows of group build on another column

[jkpf23]

Hi,

I got a problem with creating the measure that could tell me if all values filtered by one filter on a single columns, covers all values of this specific segment they belongs to (segments in another columns). 

Let me explain that on example:

I got structure table - each retailer belongs to the country and countries belongs to regions. 

On the report I got one filter - retailer, with multiple selection option.

I would like to have a measure that could tell me on which granularity level the report stands after using filter above (levels: global, region, country, retailer). 

So if the user will select all the retailers from Russia, let's say, I would like the measure to return 'region', as all the retailers from Russia are selected and at the same time EEU is fully selected, as all the 'full' countries from EEU are selected (only Russia for now). But if in the EEU was another country, I would like the measure to return 'country', as the maximum 'full' level is country (Russia is 'full', but EEU not).

If there are two retailers selected from different countries - ex. beru.ru and bol.nl, then the measure should return 'retailer' as there is no any 'full' country nor the region. 

At the same time I would like it to display retailer level if there is more than one region selected (even if retailers creates two 'full' regions, or two 'full' countries from different regions)

If that is even possible?

Thanks for your help! I really can't figure it out and really need that 🙂 

[lbendlin]

Here are the functions that you need to resolve this

FILTERS()

VALUES()

ISFILTERED()

ISINSCOPE()

Please provide sample data in usable format and show the expected outcome.