Calculate the Average from the sum of a day

[MakingBreaddata]

Hey together, 

i´ve got a problem with a Measure im collecting the data of the disposed parts in our production. The employes are booking it to our system the whole day and assign it to a production line. Looks like this:

now i want to know what is the avarage in a day based on the sum  of all days on each line. The Goal is to compare the dayl disposal with a the average disposals from the last months (The whole Data). I tried a lot of combinations but nothing worked out. 

the Graph for the daily disposal looks good (it is separatet in two classes disposed and reworked). At least i only need a Measure to which can be used to compare the average.

Thanks in advance

[Anonymous · Accepted solution]

Hi @MakingBreaddata,

You can try to use the following measure formula if it suitable for your requirement:

formula =
VAR summary =
    SUMMARIZE (
        Table1,
        [Category L],
        [Date],
        "Total", SUM ( Table1[Value] )
    )
RETURN
    AVERAGEX ( summary, [Total] )

Regards,

Xiaoxin Sheng