Can I get the name of the group workspace a report is under?

[NuTek]

I would like to hide the values of specific columns based on the workspace name.. That way I can publish the same report to multiple workspaces and the reports content will be adjusted for the users viewing the report.. 

ex: 

1. Created a report showing inventory and prices.
2. Set measure called "Price" that checks workspace name and returns either the real price or a null.
3. Publish report to two workspaces (ViewPrice and HidePrice)

Those users opening the report under "ViewPrice" group would see the price while those opening the report under "HidePrice" wouldn't.

Is this possible?  Perhaps there is a better way of hiding columns based on user groups? (not rows, but columns)

Thanks!

[v-shex-msft]

Hi @NuTek,

It is impossible to use dax get the workspace name.

>>That way I can publish the same report to multiple workspaces and the reports content will be adjusted for the users viewing the report.. 

If you want do some dynamic change, I'd like to suggest you take a look at dynamic RLS:

Power BI – Dynamic Row Level Security – Tips to get it working!

Regards,

Xiaoxin Sheng