Count Dynamic Value

[NadaFathy193]

Hi All , 

If I have below table 
and i need to use power BI to  count the Sub product for the product , but the products are dynamic and the subproducts are dynmaic as well 

product  ProductSub

A	TSa001
B	TSa002
C	TSa003
D	TSa004
A	TSa005
B	TSa006
C	TSa007
D	TSa008
A	TSa009
B	TSa010
C	TSa011
AD	TSa012

[NadaFathy193 · Accepted solution]

I also found this Solution 
CountSUBprodut = CALCULATE(COUNT('X'[Subproduct]),ALLEXCEPT('x','x'[Prodct]))

thank you for your response😊

[rajendraongole1]

Hi @NadaFathy193 - Create one new table productlist that shows only unique records.

to get the unique records :

ProductList = DISTINCT('YourTable'[Product])

Create a measure that calculates the count of sub-products for each product.

SubProductCount =
CALCULATE (
COUNTROWS('YourTable'),
FILTER (
'YourTable',
'YourTable'[Product] = SELECTEDVALUE('ProductList'[Product])
)
)

Now display the product names from the "ProductList" table and use the "SubProductCount" measure to show the count of sub-products for each product which dynamically counts the number from sub product group to each product

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!