CALCULATED COLUMN Distinct count

[joshua1990]

Hi community!

I have a simple table with this structure:

Order	Article	Value
100	A	4
100	B	5
100	C	6
101	A	5

Now I would like to add an additonal column the shows me per Order the number of articles.

But how?

[daXtreme · Accepted solution]

[# Articles] = // calc column
var OrderId = T[OrderId]
return
COUNTROWS(
    SUMMARIZE(
        FILTER(
            T, // name of the table
            T[Order] = OrderId
        ),
        T[Article]
    )
)