I want to create a calculated table with Region and Sales where the sale is greater than 500,000.
This is the DAX I created to generate the table.
I can also create a text based filter condition, but I am unable to create the numerical condition.
FILTER(Orders, Orders[Region] = "South"),
"Sale", SUM ( Orders[Sales] )