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

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