Forum Discussion
All Function
Hi all , Max Date new 3 =
CALCULATE(
MAX('Date'[Date]),
FILTER('Date',[Total solar Generated] >= 0.1),
ALL('Date'),
ALL('NGD'[Meter Name (groups)]))
...
Hi JamesBurke - you can refine your DAX formula by making full use of the all function as below
Max Date Overall =
CALCULATE(
MAX('Date'[Date]),
FILTER('Date', [Total solar Generated] >= 0.1),
ALL('Date'),
ALL('NGD'[Meter Name (groups)])
)
Hi rajendraongole1 ,
This hasn't seemed to solve the issue , the data is still being filtered by each indivdiual block still.
Not sure wether it being in the same table akes a difference or not ?