Forum Discussion

cham's avatar
cham
Post 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
Community 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
Post Patron
7 years ago

Afte I do that its giving errors