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 ...
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😊

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