Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ThomasRichard
Helper I
Helper I

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.

Screenshot 2.png
Thanks a lot in advance,
 
Thomas
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

 

View solution in original post

2 REPLIES 2
ThomasRichard
Helper I
Helper I

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

amitchandak
Super User
Super User

@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

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.