filter data by groups

[Jordi]

Maybe it is an very obvious question, but I'm not sure how to search for it (in english) so I'll give it a try here.

I have a table with invoices with sales for a file (every file has an amount of sales).

File  invoiceid  Sales  Pax

1      1              1000    2

1      2                 500   2

2      3                 500   2

3      4                 500   1 

3      5                1000  1

4      6                1500   2

4      7                1000   2

What I want is an count of files grouped by the total sales amount:

Sales         #Files

0-1000           1

1000-2000     2

>2000            1

What is the best way to achieve this?

[Zubair_Muhammad]

Hi @Jordi

You can do this with the help of a small PARAMETER table

Please check this post..

http://community.powerbi.com/t5/Desktop/Company-Durations/m-p/365503#M165285

[Jordi]

Thanks for the hint @Zubair_Muhammad

Added the Parameter table, and added a calculated column with this formula: (I want to count the Files within the parameters)

Category = 
VAR Sales =
SUM('Sales'[sales])
RETURN
CALCULATE (
DISTINCTCOUNT('Sales'[File] );
FILTER (
Parameters;
Sales >= Parameters[Start]
&& Sales < Parameters[End]
)
)

But that return the value "1"

Table "Parameters"

(Column "Index" is added for ordering purposes)