Forum Discussion
Count measure in Matrix
Hello everyone,
Thanks in advance for your time and help.
Here is a sample of my table :
I am trying to create a Matrix that counts the number of transactions per responsable & per status of transaction.
My Matrix should look like that :
In the Matrix above, the names displayed in lines is taken from another table that just list the names in a column named "Responsable names"
I am looking for the right formula for my measure to count the transactions. I have tried many things.... It never fits.
ps : When there are 2 responsables for one transaction, it should be counted as 1 for responsable 1 and 1 for responsable 2.
If anyone has a clue, I would be very grateful.
Thanks a lot
2 Replies
- Why have you not given us a small but fully functional example? Your matrix is empty, so we can't see any numbers. Please refer to this article to know what's the best way to post questions and maximize the chance of getting a good answer:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 - DataInsights
Super User
Anonymous, try this measure. You'll need to create two relationships as shown below.
Transaction Count = VAR vPerson1 = COUNT ( 'Transaction'[Transaction ID] ) VAR vPerson2 = CALCULATE ( COUNT ( 'Transaction'[Transaction ID] ), USERELATIONSHIP ( Person[Name], 'Transaction'[Responsible for transaction 2/2] ) ) VAR vResult = vPerson1 + vPerson2 RETURN vResultSample data:
Active relationship:
Inactive relationship:
Use Person[Name] in the matrix rows. The Person table is a list of all names.
Result:
