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_...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    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
    8 years ago

    v-qiuyu-msft

     

    Thank you! Now it works perfectly!

     

    Much appreciated!

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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