Dropdown with distinct fields and "all"

[Anonymous]

Morning, 

I have a data card that has a dropdown menu for quarters that are pulled from a SharePoint list.  Once selected I have labels that pull the sum of other columns for the selected value of the dropdown for each column in my SharePoint list.  

Example:  User selects "1" and the Email Sent label is updated with the total count of emails sent for Quarter 1 from the SharePoint list

In my dropdown.item field I have the following:

["1", "2", "3","4", "All Quarters"]

Below my drop down field I have the labels with the text that shows: 

Sum(Filter(DataSource,QuarterEvent = Dropdown1.Selected.Value),Emails_Sent)

This works great when a user selects the values 1-4, but I can't figure out how to have the labels show the sum of all quarters when selecting "All Quarters" 

Any insight would be helpful - I am a bit new to PowerApps so this may be a noob question.  Thank you for hte help! 

[CarlosFigueira · Accepted solution]

You can combine multiple conditions with the "Or" operator, and use an expression like the one below to accomplish what you need:

Sum(
    Filter(
        DataSource,
        Dropdown1.Selected.Value = "All Quarters" Or QuarterEvent = Dropdown1.Selected.Value),
    Emails_Sent)

[Anonymous]

Thank you Carlos - that worked perfect!  Appreciate the help and solution provided