Average calculation issue with Direct Query mode - Sprinklr

[Veternus]

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 SUM totals are functioning well; however, I am encountering an issue with calculating average durations. The values for time durations (of our calls) only display as SUM totals (as seen in the image below), resulting in numbers in the millions.

When I switch the visualization to Average, the graph only returns a zero (as seen in the pictures below).

This exact issue was previously discussed here: https://community.fabric.microsoft.com/t5/Desktop/Average-calculation-issue-with-Direct-Query-mode/m..., but no solution was found.

Has anyone successfully tackled this issue since then?

Thank you and have a great day!

[DataInsights]

@Veternus,

Have you tried creating an explicit measure (DAX)? I don't have access to Sprinklr data so I'm unable to test it.

[Veternus]

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.

[DataInsights]

@Veternus,

That's strange. You might try the DAX function TOCSV to get visibility into the underlying data:

https://dax.guide/tocsv/ 

[DataInsights]

@Veternus,

Try calculating the average manually.

Numerator: SUM

Denominator: COUNTROWS

[Veternus]

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.