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!
