Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

KPI 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 ...
Need Help
Show and Tell
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    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.

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

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's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
3 years ago

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's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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")