Distinct Row Count with filter for Transaction Amount
I'm looking to get the distinct count of rows when the transaction amount is below a certain value. It also will not let me place a visual level filter on the card of the count.
CALCULATE(DISTINCTCOUNT('Transaction History'[ORDER_NUMBER]),[Transaction Amount]<500) but i get this error: "A function "Calculate" has been used in a True/False expression that is used as a table filter expression. This is not allowed."
I also tried
Order under 500 = countrows(DISTINCT(SELECTCOLUMNS('Transaction History',"under 500",[Transaction Amount]<500))); but it gives me an incorrect count.
I have a table as below:
Sum of Order Amount
I want a card to show the number of orders below $500 (3).