Forum Discussion
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...
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
How do you 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.
Can you Help me, I jave the same problem!