Forum Discussion
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 differen...
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
amitchandak Thank you very much, it seems to be working this way!