Summarize Table with different Filters for each column

[ThomasRichard]

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]

@amitchandak  Thank you very much, it seems to be working this way!

[amitchandak · Accepted solution]

@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