Forum Discussion
Veternus
2 years agoFrequent Visitor
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 ...
DataInsights
2 years agoSuper User
That's strange. You might try the DAX function TOCSV to get visibility into the underlying data:
DataInsights
2 years agoSuper User
- Veternus2 years agoFrequent Visitor
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.