Forum Discussion
Help with measure
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.
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?
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.
It looks like there may be an issue with your model, does the "total calls by ext..." table combine the calls in and out?
If so using it to link through to the extentions table may cause issues.
Try changing the link from calls table to link directly to extensions.
I find this quite useful to describe how to set up tables and links - http://www.powerpivotpro.com/2015/10/giving-back-steal-this-reference-card/
