Table with only filtered data

Hi,

If your eally want to implement security, wouldn't it be better to use RLS ?

With RLS you can create roles and assign to each role, which lines are filtered or not.

RLS works only if you publish your report to PBI service, so I don't know if this is possible for you (licence or not and which one).

Hope it helps

Hello JosueAbreu this can be achieved through the ISFILTERED function.
Here is the URL - https://learn.microsoft.com/en-us/dax/isfiltered-function-dax
Here is my sample solution if it helps - https://1drv.ms/u/s!ArEx6MabNbWofWqfh3B187qcxWI?e=G0uvOg