Manager can drill-through, Employee must not. DAX for user dependent drill-through wanted.

[Cars10]

• I want to show/hide a drill-through right-click option to certain user groups only. 🤔🤔
  
  
  
  
• I use a table Tab1 with Columns Col1,Col2 on the first tab of a report:
  Col1, Col2 
  A,6
  B,7
  C,8
  D,9
  
  
• And another Table Tab2 on a second tab with columns 
  Col2,Col3
  7,one
  7,three
  7,two
  8,four
  9,five
  
  
• There is a relationship between those two tables via Col2. 
  
  
  
  
• To create a drill through I drop  Col2 into the drill through area
  
  

• My Question: Depending on the user in the Users Table (in my project I use Roles and Filters)  how can I show or hide the drilldown right click option

  
  
• 
• THANKS a lot for your help in advance.

[v-kkf-msft]

Hi @Cars10 ,

Accroding to my understanding, you don't hide a drill-through right-click option to certain user groups. You can only hide the data of the Col3 column in drillthrough page like this:

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cars10]

Hi v-kkf-msft, 
thank you very much for your answer but the solution doesn't hide the drillthrough. Sure I can use RowLevelSecurity but then I offer the user an empty page.

I was thinkin of a DAX Expression on Page 2 like:

Visibility = IF (User = "Manager", Col2, BLANK())

In case of BLANK() the user won't see a drillthrough on right click.

Thanks in advance.