Grouping the count of components

[Chaithanya89]

Hello Friends,

I am working on building a PBI dashboard for some KPIs.

By using distinct count measure i have calculated the number of components under a particular product ID (Table 1). 

Product ID	No of components
jbfr	15
kszq	16
ir81	14
1omv	15
ejxd	18
p0hn	18
dmbq	15
odhq	16
37di	19
v2x9	18

The count of the number of components are of different types (Table 2) 

Components	Component type
xx	Type 1
xy	Type 2
xz	Type 3

I would like to have a table which shows the count of the type of the components

 For example:

Product ID	No of components
jbfr	15
Type 1	10
Type 2	5

Can someone help me how to create this dax measure?

Thanks and regards,

Chaithanya

[lbendlin · Accepted solution]

Please don't do that.  Data duplication inevitably leads to user confusion.

Instead, let the data model do the work for you and use a matrix visual to show the product/component hierarchy.

[Ashish_Mathur]

Hi,

You have just shared the result you want, not the raw data tables.