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 showing that "this user did not answer any calls at this moment".

 

If the user select that particular user name if filter slicer, card need to be show automatically saying that "this user did not answer any calls."

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 )

7 Replies

  • AlB's avatar
    AlB
    Community 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
      Post 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
        Community 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 )