@EmGriff
The issue you are running into is that Calculate can take simple filters, like Product [Color] = “Red” or something similar. Once you introduce a more complex filter, Facts[UnitPrice] >= 50, calculate does “know” what to do with that. So you need to use Filter (which is an iterator, so it will iterate the facts table and keeping all the rows where Unit Price > 50) and that table will be aggregated over.
You can most definitely use measures in your filter statements, and honestly, you would be better off doing that more often than not because depending on your formula.
I think you’ll also find that you are likely using a measure here for Unit Price instead of a column.
So there’s a few places where this is falling over for you.
You need to use FILTER here, which is very easy to do and gives you a lot more flexibility in the calculations you are doing.
I actually use FILTER on nearly all occasions just because I know that it’s much more versatile. It’s really important to actually understand what FILTER is doing by iterating through the table that you give it. This is a very key concept to master early on with Power BI.
Please check out the below tutorials to learn more around this.
