Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Product Counts Based on Measure Values

Hi All,   I am new to Power BI. We need to count the products based on target values. The Product count should contain target values. In the screenshot, we have 16 products but the expected count...
Need Help
Tips and Tricks
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    Ok check this one, 
    Here i have created one random measure.

    Measure = SUM(Sheet1[Target])*AVERAGE(Sheet1[Column])
     
    And taking count using below image by creating new measure 
    Count Using Measure = COUNTROWS(FILTER(VALUES(Sheet1[Product ]),[Measure]>0))

    Hope this works. IF not please provide more information regading target measure.
    Thanks

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Solution Sage
2 years ago

Hi Anonymous 

Please check this solution. Here i have taken sample data with 10 Products with target values.

Here i have 8 poduct value haveing target greater than 0 so count should be 8. And here i have created the measure 

Product Without Zero Target = calculate(count(Sheet1[Product ]),Sheet1[Target]>0)
And here is the output for the same 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

If it does not help, please provide more details with your desired output and pbix file with privacy information (or some sample data).

 

Best Regards

 




  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, 

    Thanks for your response.

     

    But my target is displayed by measure value. Based on the measure we need to take the count.

    • qqqqqwwwweeerrr's avatar
      qqqqqwwwweeerrr
      Solution Sage
      2 years ago

      Ok check this one, 
      Here i have created one random measure.

      Measure = SUM(Sheet1[Target])*AVERAGE(Sheet1[Column])
       
      And taking count using below image by creating new measure 
      Count Using Measure = COUNTROWS(FILTER(VALUES(Sheet1[Product ]),[Measure]>0))

      Hope this works. IF not please provide more information regading target measure.
      Thanks