Forum Discussion

Arne's avatar
Arne
Frequent Visitor
6 years ago
Solved

Filter solution

Hi! From the example below i would like to filter sales in period 2020-01 where sales is more than 80. But i would likte to get all periods for companys that have sales of more than 80 in period 202...
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Arne ,

    Try this measure:

     

    Measure 2 =

    VAR _company = SELECTCOLUMNS(FILTER(ALL('Table (3)'); 'Table (3)'[Sales] > 80 && 'Table (3)'[Period] = DATE(2020; 1;1)); "Company"; 'Table (3)'[Company])
    RETURN SUMX(FILTER('Table (3)'; 'Table (3)'[Company] IN _company); 'Table (3)'[Sales])
     
     
     
     
     
    Ricardo
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
So maybe:

FILTER('Table',[Company] = "Amazon" && [Sales] > 80)
Arne's avatar
Arne
Frequent Visitor
6 years ago

Hi Greg!

In the example it would work but in my solution i,ve got hundreds of departments so i would need some solution that first filters out every department that has sales over a specific limit for a selected period and then i would like to see sales trends for these companys for the periods i choose.  So it,s really a two step issue.

1. Find companys that qualify for selected sales level for the period i choose.

2. For companys that qualify for the first criteria show sales level for the period in first critera but also for other chosen periods.

Br Arne