Hello! I’m trying to setup a multi-filtering controls that filter a summary table data.
If one of the filter criteria field is empty a need the sum of all values (not apply that filter)
I could make it work with 2 criteria: date range and customer and want for example add a supplier filter.
But the formula code is becoming messy and looks not scalable.
I paste the 2 filters working formula here and try to attach a document (this is my first post):
If( Filters.CustomerValue.Count()=0, PurchaseData.Filter(Date.Matches(PurchaseDateRange)).Cost.Sum(), PurchaseData.Filter( Customer=Filters.CustomerValue AND Date.Matches(PurchaseDateRange) ).Cost.Sum() )
I can’t find a way to keep adding filters criteria to this formula.
Many thanks for your support!