Forum Discussion

LogMill1's avatar
LogMill1
Frequent Visitor
3 years ago
Solved

Counting Distinct Pairs

I have two columns that pair with eachother and I am trying to count the distinct pairs.

 

For example:

StartEnd
AB
AB
AB
BC
BC
BC
BC
CD
CD

 

So the measure would count

Start A, End B once,

Start B, End C once, and 

Start C, End D once

 

Thank you in advance for any help/clarification

  • Hi LogMill1 

    pleaae try

    Count =
    COUNTROWS ( SUMMARIZE ( 'Table', 'Table'[Start], 'Table'[End] ) )

3 Replies