Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post 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 blank?

 

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

 

 

 

 

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.

5 Replies

    • gauravnarchal's avatar
      gauravnarchal
      Post Prodigy
      3 years ago

      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

       

  • mangaus1111's avatar
    mangaus1111
    Solution 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
      Post 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
        Solution 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")