Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 sta...
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
6 years ago

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
    vResult

 

Sample data:

 

 

Active relationship:

 

 

Inactive relationship:

 

 

Use Person[Name] in the matrix rows. The Person table is a list of all names.

 

Result: