I have a bucket table (RevenueTarget) which has the following data:
I have a measure on my main fact table which looks up the target:
Revenue Target:=CALCULATE(MAX(RevenueTarget[RevenueTarget]),FILTER(RevenueTarget,LASTNONBLANK(YearMonth[YearMonth],0)=LASTNONBLANK(RevenueTarget[YearMonth],0) && LASTNONBLANK(CustomerSiteAddress[Region],0) = LASTNONBLANK(RevenueTarget[RegionName],0)))
The issue which I have is that when I select mutiple regions the target isn't aggregated. The DAX expressions works well when selecting one region but doesn't work for multiple regions.