Measures with CALCULATE statement not working when RLS is turned on

[Anonymous]

I have an issue with CALCULATE measures and RLS. I have created a measure to find cumulative total % of calls answered within bins of queue time. 

Expression: CumulativeCalls = IF(COUNTROWS(PowerBI_Cust_Comp) > 0; CALCULATE(COUNT(PowerBI_Cust_Comp[CorrelationID]);FILTER(ALL(PowerBI_Cust_Comp[RightQueueTime (bins)]); PowerBI_Cust_Comp[RightQueueTime (bins)] <= max(PowerBI_Cust_Comp[RightQueueTime (bins)])));BLANK()) 

CorrelationID is the ID of the call and RightQueueTime is the time customers are waiting before the call is answered. The measure behaves differently when I view the report as another user in a specified role compared to when I view the report with only a slicer creating the same filter. 

Measure behavior when RLS is turned ON: https://goo.gl/KCV8zj 

A cumulative measure should not decrease along the x axis. 

Anyone else with this issue?

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Please modify the measure like below then test again. 

CumulativeCalls = IF(COUNTROWS(PowerBI_Cust_Comp) > 0; CALCULATE(COUNT(PowerBI_Cust_Comp[CorrelationID]);FILTER(ALLSELECTED(PowerBI_Cust_Comp); PowerBI_Cust_Comp[RightQueueTime (bins)] <= max(PowerBI_Cust_Comp[RightQueueTime (bins)])));BLANK()) 

Best Regards,
Qiuyun Yu 

[Anonymous · Accepted solution]

@v-qiuyu-msft

Thank you! Now it works perfectly!

Much appreciated!

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Please modify the measure like below then test again. 

CumulativeCalls = IF(COUNTROWS(PowerBI_Cust_Comp) > 0; CALCULATE(COUNT(PowerBI_Cust_Comp[CorrelationID]);FILTER(ALLSELECTED(PowerBI_Cust_Comp); PowerBI_Cust_Comp[RightQueueTime (bins)] <= max(PowerBI_Cust_Comp[RightQueueTime (bins)])));BLANK()) 

Best Regards,
Qiuyun Yu