Forum Discussion

ThomasRichard's avatar
2 years ago
Solved

Summarize Table with different Filters for each column

Hi all,

 

I created a new table to summarize my data. I am doing totals for each individual.

 

I applied the filters needed for the first column, however I want to add other columns with different filters (especially different date filters).

 

Looking at the picture, my table is summarizing for each player, my 2 first columns "Microcycle HSR" and "Microcycle Total Distance" were date filtered by 

'Date'[Weekly Microcycles]="W06"
 
And I would like to add more columns with a different date filter (for example 'Date'[Weekly Microcycles]="W07")
 
The column with errors is a trial to do it with a new column, but I don't know how to match the summary, plus I would ideally code it directly in the creation of the table.

Thanks a lot in advance,
 
Thomas
  • ThomasRichard ,  You can move the filter to Summarize for each expression

     

    Example

    "M1", calculate(sum(Table[Value]), filter(Table, Table[Period Name] in {"P1", "P2"} && Table[Col] = "A"))

     

    Prefer in over OR

     

2 Replies

  • ThomasRichard ,  You can move the filter to Summarize for each expression

     

    Example

    "M1", calculate(sum(Table[Value]), filter(Table, Table[Period Name] in {"P1", "P2"} && Table[Col] = "A"))

     

    Prefer in over OR