Forum Discussion
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 thinking that it would filter using the slicer only the values I need.
Calls In = COUNTROWS(FILTERS(Calls[ToNumber]))
For each individual selected in the slicer it shows the same number which I figured out is the total distinct values from the dataset instead of the total for each person selected in the slicer. I know Im missing something I just can't pinpoint the problem.
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.
11 Replies
Just use
Calls In = COUNTROWS( Calls )
That returns all calls. I am trying to use a slicer to view calls for specific users.
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?
