Creating Measure to count values ​​with condition

[powertechbi]

Good afternoon
I would like to ask for help in resolving an issue.
I have a relationship with some products and I need to generate a measure that calculates the number of items I have in stock equal to or greater than zero, however, when generating the measure, the message shown in the image appears.
Would anyone have any idea how to proceed?
Thank you in advance.

[Anonymous]

Hi  @powertechbi , Ashish_Mathur, lbendlin, thank you for your prompt reply! 

It seems that you need to change your Return value with table column instead of measure:

For example:

RETURN CALCULATE(_TIPOS, Fato[Estoque Atual] >= _VALOR1)

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Share some data to work with, describe the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[lbendlin]

Do not filter tables. always filter columns.  https://www.sqlbi.com/articles/filter-columns-not-tables-in-dax/