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

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

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.

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

      Afte I do that its giving errors