Average of distinct values

[brucruz]

Hello,

My table contains sales transactions organized by two important columns: "COD CLIENTE" for the customer id, "SKU" for the product id.

I created a measure "#SKU" to distinct count the number of products ids and I can visualize it in a table per client id. But I cannot identify the average count of product ids per customer id.

What is the best way to do it?

For example:

CLIENT ID   DISTINCTCOUNT OF PRODUCT ID

01               2

02               3

03               1

Average of Distinct Count of Product ID per Client ID = 2

[Zubair_Muhammad · Accepted solution]

@brucruz

Try a Measure on the following lines

=
AVERAGEX (
    ALLSELECTED ( TableName[Client ID] ),
    CALCULATE ( DISTINCTCOUNT ( TableName[ProductID] ) )
)