Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Average calculation issue with Direct Query mode

Hello,   I'm currently working on Sprinklr data exploitation in PowerBI by using the dedicated Spark connector (DirectQuery mode). All is going fine except for duration average calculation.   I'm...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello,

 

Thanks for trying to help 🙂

 

I adapted the measure and ran it, I got no error but I still have 0 as a result:

 

 

I think that the problem is at the root when calculating average variable...

 

The strange behaviour is that I can calculate the sum (so there's data) but not the average, and count is returning (Blank) value.

 

Let's see if someone has an idea to share 🤞

 

Have a nice day

changqing's avatar
changqing
Resolver II
4 years ago

Hi Anonymous ,

 

Would you please share the formula of TIME MEASURE? 

Is there row-level security?

And please check the modeling-limitations

 

Best Regards,
changqing

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello changqing, thanks a lot for helping 🙂

     

    The formula was basically the one proposed by amitchandak but the average calculation on the first line was returning 0 in all cases.

     

    There's no row-level security.

     

    I took a look at the modeling limitations and I don't really see something that could avoid me to calculate the average.

     

    That's very frustrating to don't be able to see the raw data behind...

     

    Best regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous,

      You can take a look at the following blog about aggregation on duration if it help with your scenairo:

      Aggregating Duration Tim 

      Regards,

      Xiaoxin Sheng