Forum Discussion

MrCoyado's avatar
MrCoyado
Frequent Visitor
9 years ago
Solved

Aggregated Measures with RLS

Hello everyone.   We have just implemented Power BI as our BI solution in my company (retail business). We are using RLS in our sales reports, which respect the company's hierarchy levels:   Sal...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi MrCoyado,

     

    >>Is this possible with Power BI? We've tried using functions such as ALL and ALLSELECTED, but it didn't work with RLS.

     

    Based on test, I find that RLS is filtered on the dataset(original data will be filtered), so all and allselected function not work on RLS.

     

    In my opinion, you can calculate original data at query editor or database side and summary these records to a table. Then use the summary table to compare with current data.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi MrCoyado,

 

>>Is this possible with Power BI? We've tried using functions such as ALL and ALLSELECTED, but it didn't work with RLS.

 

Based on test, I find that RLS is filtered on the dataset(original data will be filtered), so all and allselected function not work on RLS.

 

In my opinion, you can calculate original data at query editor or database side and summary these records to a table. Then use the summary table to compare with current data.

 

Regards,

Xiaoxin Sheng