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] ) )

ThxAlot's avatar
ThxAlot
Super User
3 years ago

 

= COUNTROWS( DISTINCT( Table1 ) )