Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Measures with CALCULATE statement not working when RLS is turned on

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?

  • 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 

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support

    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's avatar
    Anonymous
    Not applicable

    v-qiuyu-msft

     

    Thank you! Now it works perfectly!

     

    Much appreciated!