Forum Discussion

jbernard82's avatar
jbernard82
New Member
10 years ago
Solved

Help with measure

I've got a table full of call records and I am creating a matrix to display total incoming calls and outgoing calls for each extension selected in the slicer. I wrote the following or the measure thi...
Need Help
  • konstantinos's avatar
    konstantinos
    10 years ago

    My suggestion that is what I would do ( although don't know your other visuals ) is to create an active relantionship Extension -  ToNumber  and inactive relantionship with Extension - FromNumber..The measures can be 

     

    Calls in = COUNTROWS( Calls )

Calls Out =
CALCULATE (
    COUNTROWS ( Calls );
    USERELATIONSHIP ( Extensions[Extension]; Calls[FromNumber] )
)

    This way you won't have to change your visual or your model.

     

     

     

     

     

     

     

konstantinos's avatar
konstantinos
Memorable Member
10 years ago

Just use

Calls In = COUNTROWS( Calls )

 

  • jbernard82's avatar
    jbernard82
    New Member
    10 years ago

    That returns all calls. I am trying to use a slicer to view calls for specific users.

    • itchyeyeballs's avatar
      itchyeyeballs
      Impactful Individual
      10 years ago

      If you put the measure described by konstantinos in the values section of the matrix and put the person details in the rows section you should get a count for each person.

       

      If that doesn't work you may have a problem with your linking between tables, do you have a "relationships may be needed" warning above your field list?

      • jbernard82's avatar
        jbernard82
        New Member
        10 years ago

        When I do that I still get the same total call count for everything. I dont have any relationship errors but I had to change my model because the Calls table has a ToNumber and FromNumber and I cannot have two active relationships with the Extension column on the other table. Here is my current model.