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😊

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😊