Forum Discussion

Jordi's avatar
Jordi
Advocate I
8 years ago

filter data by groups

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 o...
Need Help
Jordi's avatar
Jordi
Advocate I
8 years ago

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)