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)