Average Per Store on Weekly Data

Hi Anonymous 

Try the folloing Dax

Weekly Average % = 
VAR TotalStores = COUNTROWS(UNIQUE('04_StoreConsoDaily'[StoreNo]))
VAR TotalPercentageSum = SUMX(
    '04_StoreConsoDaily',
    VAR StoreDays = COUNTROWS('04_StoreConsoDaily')
    VAR StorePercentage = SUM('04_StoreConsoDaily'[Adoption %])
    RETURN
    DIVIDE(StorePercentage, StoreDays, BLANK())
)
RETURN
DIVIDE(TotalPercentageSum, TotalStores, 0)

If the above Dax doesn't solve your problem, please provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.