Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
My goal is to default a location, say Sum({<Location={'Africa'}>} Sales) but it should change based on the user's selection in the location filter consisting of other continents.
Appreciate the help.
Use below measure expression :
if(getselectedcount(Location), sum(Sales), Sum({<Location={'Africa'}>} Sales))
Regards,
Aditya