Forum Discussion

NadaFathy193's avatar
NadaFathy193
Frequent Visitor
2 years ago
Solved

Count Dynamic Value

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

ATSa001
BTSa002
CTSa003
DTSa004
ATSa005
BTSa006
CTSa007
DTSa008
ATSa009
BTSa010
CTSa011
ADTSa012
Need Help
  • NadaFathy193's avatar
    NadaFathy193
    2 years ago

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

     

    thank you for your response😊

2 Replies

  • NadaFathy193's avatar
    NadaFathy193
    Frequent Visitor
    2 years ago

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

     

    thank you for your response😊

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    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!!