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

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.

 

 

 

 

 

 

 

leonardmurphy's avatar
leonardmurphy
Skilled Sharer
10 years ago

The challenge with an inactive relationship is that jbernard82 is using a slicer to filter the extension and then wants to see outbound and inbound calls for each extension. A slicer will always use the active relationship, so if an extension has only ever been a FromNumber, it would get filtered out. 

 

For that reason, I'd tend to agree with itchyeyeballs regarding unpivoting the call data. 

 

If the filtering out wouldn't be an issue though, then an inactive relationship is definitely a more straightforward solution to the immediate problem of counting calls.

  • jbernard82's avatar
    jbernard82
    New Member
    10 years ago

    Thanks konstantinos! That did the trick. The slicer does still appear to work with the inactive relationship.