Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Try a Measure on the following lines
= AVERAGEX ( ALLSELECTED ( TableName[Client ID] ), CALCULATE ( DISTINCTCOUNT ( TableName[ProductID] ) ) )
Try a Measure on the following lines
= AVERAGEX ( ALLSELECTED ( TableName[Client ID] ), CALCULATE ( DISTINCTCOUNT ( TableName[ProductID] ) ) )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |