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: Start End A B A B A B B C B C B C B C C D C D   ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi LogMill1 

    pleaae try

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

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi LogMill1 

pleaae try

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