Forum Discussion
gauravnarchal
Post Prodigy
Post ProdigyKPI Indicator Card showing blank
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 ...
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&":"&_SecondsIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mangaus1111
Solution Sage
Solution SageHi gauravnarchal ,
dou you have some sample data to share? then I can try to debug your measure.
gauravnarchalPost Prodigy
Post ProdigyHi 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.