Calculate subtotals and filter those subtotals of an table

[jhaastBI]

Hi People,

Most of my data is detailed item line level and is not summarized data. 

An example, multiple orders and each item of an order stored on a separate line: 

Order	Item	Price
1000	Laptop	€850
1000	Keyboard	€150
1001	Laptop	€650
1001	Keyboard	€100
1002	Laptop	€1.250

I want to know how many orders are smaller than €1.000.

Can somebody tell me how I can calculate this without creating a new table?

Thank you in advance.

[amitchandak · Accepted solution]

@jhaastBI , Try measure like

count order = countx(filter(summarize(Table, Table[Order],"_1" ,sum(Table[Price])), [_1]<1000), [Order])

Sum Price = countx(filter(summarize(Table, Table[Order],"_1" ,sum(Table[Price])), [_1]<1000), [_1])

[jhaastBI]

Thank you a lot! That is the solution.