Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
brucruz
Frequent Visitor

Average of distinct values

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

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@brucruz

 

Try a Measure on the following lines

 

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

Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

@brucruz

 

Try a Measure on the following lines

 

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

Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.