Columns masking in SSAS DAX

Question

Hi Team,

I am having 7 columns in a table , Wanted to mask columns bases on the condition?

For Example: If user =A then we should show all the 7 column values are blank
if user= b Then we should show 5 column values with blank remaing 2 columns with their values

Can you help me on how can I achieve this?

Thanks In Advance

Answer 1

Hi @Sahoo ,

Welcome to Microsoft Q&A!

As my research, dynamic Data Masking does not support in SSAS. But you could refer to below threads, try to set some permissions:
SSAS Feature to hold confidential data
Masking Dimension attribute / Security in SSAS

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.