Forum Discussion
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...
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.
I guess I could just duplicate the Calls table just to get the relationship for this to work but that could mess up other visuals unless creating a relationship between the two on the CallID field would take care of that. Thoughts?
You need to get your model right before you go any further otherwise your measures will become ever more complex to get around underlying issues.
As mentioned in your other thread, I would look at unpivoting the calls table so that incoming and out going calls are separate rows. If every call has a unique Id you can avoid double counting internal calls by filtering in your measures
As mentioned in your other thread, I would look at unpivoting the calls table so that incoming and out going calls are separate rows. If every call has a unique Id you can avoid double counting internal calls by filtering in your measures