Forum Discussion

Seth4040's avatar
Seth4040
Regular Visitor
1 year ago

Average based on Filter

I am trying to get the average of project completions per week and then when I am changing the filter as what weeks I am seeing that the average would be tied into this filter.  It is currently do th...
"average"
sanalytics's avatar
sanalytics
Icon for Super User rankSuper User
1 year ago

Seth4040 
Can you use below code and see if it is working or not.. if not then requesting you to provide some dummy data along with your desired output.

Average Value = 
VAR FilteredValues = 
    CALCULATETABLE(
        VALUES(Table[Value]), 
        ALLSELECTED(Table)
    )

RETURN 
    AVERAGEX(FilteredValues, Table[Value])

Regards,

sanalytics