Forum Discussion

powertechbi's avatar
powertechbi
Frequent Visitor
1 year ago

Creating Measure to count values ​​with condition

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.

Need Help

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.