Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Using two filters with CALCULATE

I have large spreadsheet with a date in one column, and a string value in another column and I need to produce a table with count of each string value for a given date range.   So far I have Table ...
Need Help
  • AlexChen's avatar
    AlexChen
    9 years ago

    Hi Concat,

     

    Just as what scottsen said, you have to use Measures here not Calculated columns.

     

    By the way, if you want to get the topn records of a table by some conditions such as a specific date as you mentioned, you don't have to use rankx, you can create a table using code below to get top 5 records with filtered date:

     

    Table 2 = TOPN(5, Filter(SheetTable, SheetTable[date] > Date(2016, 7, 1)))

     

     

    Best Regards

    Alex

twahl's avatar
twahl
Frequent Visitor
8 years ago

Is there a way to apply filters from another table? 

 

Column = CALCULATE(
                    count('Table1'[ColumnID]),
                   'Table1'[ColumnStatus] = "Inactive" && Table2[Columnflag] = 7
                  )