KPI Card

[Anonymous]

-

[rajendraongole1]

Hi @Anonymous - Create the below cumulative average measure

Cumulative Boxes Average =
CALCULATE(
AVERAGEX(
SUMMARIZE(
FILTER(
ALL('BOXES PER QC'[SHIFT_DATE]),
'BOXES PER QC'[SHIFT_DATE] <= MAX('BOXES PER QC'[SHIFT_DATE])
),
'BOXES PER QC'[SHIFT_DATE],
"MonthlyAverage",
DIVIDE(SUM('BOXES PER QC'[NUMERATOR]), SUM('BOXES PER QC'[DENOMINATOR]))
),
[MonthlyAverage]
),
REMOVEFILTERS('BOXES PER QC'[SHIFT_DATE])
)

It works. Please check