Forum Discussion
Average calculation issue with Direct Query mode - Sprinklr
Hello good people, Currently, I'm trying to integrate data from Sprinklr into our Power BI report. I am connected to Sprinklr using Spark and Direct Query mode. Graphs displaying percentages and ...
Have you tried creating an explicit measure (DAX)? I don't have access to Sprinklr data so I'm unable to test it.
Hello and thank you for your reply,
When I've tried to Average the column using DAX, it returned 0 as well. I'm currenty trying to find the right values to manually average the SUM of mentioned column, but with no use - it returns unexpected and completly wrong results.
That's strange. You might try the DAX function TOCSV to get visibility into the underlying data:
