PowerPivot that behaves like 'group by having'

[pennysmith]

I newish to PowerPivot. Though I have used quite a bit of SQL.

I'm using PP just fine and am writing measures and creating relationships.

However I want to know if can I do this?
Suppose I create a measure to sum all sales for products. Call this [TOTSALES]
Now I only want to see [TOTSALES] > 1000.

I know I can sort by [TOTALES] and even have a rank.

But I only want products with [TOTSALES] to appear in my Pivot Table.
Is this possible?

So in SQL speak, this would be a bit like select prodcode, sum(sales) As TotSales from sales group by prodcode having sum(sales) > 1000


Apologies if this is a really dumb question.

Thanks in advance,
PS
Note: A moderator moved this message to the Excel Forum. This is not an excel problem. I am using PowerPivot connected to a database with many tables.

​

 

[paivers]

Try a measure like this: BigSales:=SUMX(FILTER(ALLSelected('SalesTable'),SalesTable[Sales]>1000),SalesTable[Sales]) - Pete

 

[miguel.escobar]

what about just wrapping things up with an =IF( [your measure] >1000, [your measure], blank()) ?
if your measure its something like =SUM(table[column) then the IF should be easier than the SUMX as the SUMX would iterate over the entire table and the IF would only be hitting the performance after the first SUM.