I need to be able to show an average per year per group and show in a table that has been filtered to only show the current day.
My measure is
YTD (BOPD) = calculate(average(Actuals[bopd]), filter( all(Actuals), Year(Actuals[full_date])) = year(today())))
The resulting table (which has a visual level filter of showing only today) shows a single value for the YTD figure across all of the groups. I need an average calculated by each group.
Its as if the calculation is ignoring the relationship and I dont know how to get it to use it.
Any help would be appreciated.
Hi @suzsword ,
I'm not sure if my formula will work as I don't have reproduce your scenario, please try the formula below.
YTD (BOPD) = CALCULATE ( AVERAGE ( Actuals[bopd] ), ALLEXCEPT ( Actuals, 'Actuals'[GroupName] ), FILTER ( ALL ( Actuals ), YEAR ( Actuals[full_date] ) = YEAR ( TODAY () ) ) )
If you still need help, please share your data sample which could reproduce your scenario and your desired output so that we could help further on it.