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 ...
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:
Thank you for your advices -
TOCSV Returns error
I'v already tried COUNTROWS, but the function alone returns "Blank" as result, dividing this way is not possible.