Dynamic Brand Navigation Based on Country Selection (Hide Pages with No Data)

Hi As_analyst  , there are many ways to achieve this. I can see you have created separate pages for all the brands. Do you have requirement of different KPIs / designs for each brand? Otherwise, a better approach would have been to use drill-through button option. Howeever considering you have different pages and you want to expose all the brand pages to all counries users, best option I think would be to create a landing page. Where user will select Country (single select), hence a brand (single select) and then have a button which will be enabled when a brand / product is selected. 

Create a simple measure:

selected_brand = SELECTEDVALUE(Pharma[BRAND_NAME]) 
use this as button destination.

 

and main page design something like below:

 

Well, I understand, UI wise, this is not the beset design, however you can certainly play around with formatting, alignment to make it look better.

Hope this helps to resolve your problem. If it does, then please mark it as solution.

Thanks - Samrat