DAX measure

[argha1]

I'm new in this field. I face a challenging problem. can anyone fix this problem?

my code -

Bulk Orders =
CALCULATE(
[Total Orders],
'Sales Data'[Order Quantity] > 1
)

show this error - "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

please share this any tips to solve the above problem.

[Sahir_Maharaj]

Hello @argha1,

Can you please try the following:

Bulk Orders =
CALCULATE(
    [Total Orders],
    FILTER(
        'Sales Data',
        'Sales Data'[Order Quantity] > 1
    )
)

[tharunkumarRTK]

@argha1 

I guess [Order Quantity] is a measure, beacause of which you are getting this error.
You can change your code in the below format:

Bulk Orders =
CALCULATE(
[Total Orders],
Filter('Sales Data',
[Order Quantity] > 1
)
)

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun