KPI Indicator Card showing blank

[gauravnarchal]

Hello

When I use the below measure, the value is returned 0 instead of blank in the table, but in the KPI card, it still shows blank. How can I get the value in the KPI card to show 0 instead of blank?

Abandoned = CALCULATE(COUNT(Table1[Call Types]), CONTAINSSTRING(Table1[Call Types],"Abandoned")) + 0

[mangaus1111 · Accepted solution]

Hi @gauravnarchal ,

try this measure

Total Call Duration = 
VAR _Sum = SUM('Test'[Call Duration (hh:mm:ss)])
 VAR _Hours = (DAY(_Sum)+1)*24 + HOUR(_Sum)
 VAR _Minutes = MINUTE(_Sum)
 VAR _Seconds = SECOND(_Sum)
 RETURN
 _Hours&":"&_Minutes&":"&_Seconds

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[gauravnarchal]

Hi @mangaus1111 

The measure which you have suggested is working, but when I add the "Area" into the page level filter, it gives me the incorrect total call duration result. What could be the reason?

Thanks

[mangaus1111]

Hi @gauravnarchal ,

the problem is that the time format in power bi does not show values more than 24 hours.

I suggest you to create 2 cards, one for the hours, the other for minutes and seconds. If you use the filter pane works good.

HH = INT(SUM(Test[Call Duration (hh:mm:ss)])*24)

MM-SS = FORMAT(SUM('Test'[Call Duration (hh:mm:ss)]),"nn:ss")

[mangaus1111]

Hi @gauravnarchal ,

dou you have some sample data to share? then I can try to debug your measure.

[gauravnarchal]

Hi @mangaus1111  - I have fixed the count measure. Can you help me fix the total call duration KPI card? It is showing the incorrect total of time.

I have attached the PBIX for your reference.

Click Here