Forum Discussion

cham's avatar
cham
Icon for Post Patron rankPost Patron
7 years ago
Solved

0 values

Hi,   I have a data set which includes answered and unanswered call details.   If i select one user name it will show "0' because that user didnt answer any calls. So, I want to show a card showi...
Need Help
Show and Tell
Tips and Tricks
  • AlB's avatar
    AlB
    7 years ago

    cham

    Measure for your card:

     

    Measure =
VAR NumCalls =
    SUM ( Table1[Answered Calls] )
RETURN
    IF ( NumCalls = 0; "hasn't answered any calls"; NumCalls )
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi cham

You'd have to provide more info on your tables/ data model so that we can get a detailed answer. Can you show a sample?

 

 

cham's avatar
cham
Icon for Post Patron rankPost Patron
7 years ago

Hi,

 

This is the sample data set. If I select user name as "C" in my filter slicer then i want to show a card that showing "he is not answered any calls"

 

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    cham

    Measure for your card:

     

    Measure =
VAR NumCalls =
    SUM ( Table1[Answered Calls] )
RETURN
    IF ( NumCalls = 0; "hasn't answered any calls"; NumCalls )
    • cham's avatar
      cham
      Icon for Post Patron rankPost Patron
      7 years ago

      Thank You so much

    • cham's avatar
      cham
      Icon for Post Patron rankPost Patron
      7 years ago

      Hi AlB

       

      I want to know the following thing as well.

      After I upload the below excel sheet into power bi it will show an error in the highlighted row.

      How can i change the data type in Power BI as dd:hh:mm:ss?( days, hours, minitues and seconds)

       

      • AlB's avatar
        AlB
        Icon for Community Champion rankCommunity Champion
        7 years ago

        cham

         If you select the column with the issue and go to the 'Modelling' pane you have  'Data type' and 'Format'. You can see the options for the format there.