topic Counting Distinct Pairs in DAX Commands and Tips

Counting Distinct Pairs

LogMill1 — Mon, 26 Jun 2023 15:46:59 GMT

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

For example:

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

tamerj1 — Mon, 26 Jun 2023 16:14:18 GMT

pleaae try

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

ThxAlot — Tue, 27 Jun 2023 04:17:20 GMT

= COUNTROWS( DISTINCT( Table1 ) )

devanshi — Tue, 27 Jun 2023 04:49:08 GMT

DISTINCTCOUNT('Table')