Calculated Measure

[bhmiller89]

I have a table called "Contact Notes" that includes a column called "CreatedbyUserID" and "Note."

I need to calculate how many Notes were entered for each user (by ID).

I tried Note Count= CALCULATE(COUNTA(tblContactNotes'[Note]), tblContactNotes'[IsAuto]= 0, tblContactNotes'[IsSystem] = 0)

BUT  I need to calculate quantity of notes based on the person who entered them. Right now it's populating the total based on the client name, not the user who entered the note.

[Anonymous]

What do you mean it's populating the total based on the client name? Are you charting this measure against a client name column? It looks like it would work if you charted it with the CreatedbyUserID column.

[bhmiller89]

I'm trying to replicate a spreadsheet that shows

Organization | Account Manager | TSM | Program Manager| #Notes by Account Manager| #Notes by TSM| #Notes by Program Manager

However, the measure I wrote just sums up all notes for the Organization and I don't know how to write multiple measures for each role

[Anonymous]

I still don't quite understand what you're asking for. Do you want to see a list of users with each of their total numbers of notes? If so, the measure you have written should work. You just have to plot it alongside the list of users. I assume that's the CreatedbyUserID column, but maybe you have another table of user names? That would have to be related to this notes table through the user ID.

[bhmiller89]

COL Notes = CALCULATE(COUNTA('dpmgr tblContactNotes'[Note]), 'dpmgr tblContactNotes'[IsSystem] = 0, 'dpmgr tblContactNotes'[IsAuto]= 0, USERELATIONSHIP('dpmgr tblContacts'[CustServiceRepID], 'dpmgr vwJMWebUsersSystemALL'[UserID]))

Is what I'm using. When I change the relationship to count them for the "TSM" I change The USERELATIONSHIP to map the TSMID to the UserID but Im' getting the same values for both 

[Anonymous]

It would probably help to see your table relationships.