Hello Community,
I have a scenario where I want all my tables and charts to display data based on the maximum date value. However, I also need the flexibility to apply date, month, and year filters to view specific data according to those filters. The current formula I am using is working correctly, but I believe there might be a more efficient way to achieve this. Any suggestions would be highly appreciated. Thank you!
Measure:
if(GetSelectedCount(Daily)+GetSelectedCount(MonthYear)+GetSelectedCount(Weekly)+GetSelectedCount(Year)>0,
Sum(calls),
Sum(calls))
