Measures disappear when using RLS

[K4bal]

Hi all,

I need help with a strange problem. Some of my measures disappear in PowerBI Desktop and also service when I apply / test a RLS role. A few days back it worked just fine.

Also if I refresh a table in that dataset some measure appear again and some disappear.

I hope someone can help with that!

Thanks a lot

[K4bal]

Hi @Pragati11 

mainly I'm calculate and sumx but these worked fine a few days back.

What is the most confusig is that when I refresh a table in the dataset some measures appear and others disappear. If I refresh the same table again some disappear again and others appear. But just when I "view as" a role of the RLS roles.

[Pragati11]

Hi @K4bal ,

Can you please share some screenshots around what you are seeing at your end?

RLS should never hide-unhide measures. It is for limiting access to rows of data.

[Pragati11]

HI @K4bal ,

When you say disappear, you mean you can't see them in the dataset?

Keep one thing in mind RLS doesn't support few of the DAX functions. Are you bu chance using any of these DAX functions?

Can you tell what all DAX functions you are using in your measures?

[Anonymous]

Hey guys!
I am experienceing exactly same issue. I am using SUMX with RELATED function, and whenever I use RLS View As function, all these measures dissappear. I tried to dig deeper and made a random SUMX measure in my fact, which then also dissappeared. 

Here is a screenshot of a fraction of my datamodel, the DAX function, and the RLS rule.y
To note, it is an User Defined Aggregation table.

DAX: 

Sum of Net Sales =

CALCULATE(

    SUMX(

        'Sales AGG',

        'Sales AGG'[Net Sales Acc] *

        'Sales AGG'[Tax Acc]))

RLS:

After using View As, I get the following error for my measure, and it is nowhere in the model:

[Anonymous]

UPDATE:
Seems like Aggregation tables cannot be used that easily with RLS.
Not a single measure works that is directly based on AGG table.