Weighted Result based off of Filtered Value - Help

[AndrewUrban]

Hello,

Looking for a dax formula to answer units per store per sku per week. The issue is that the time frame is aggregated (4 weeks, 12 weeks, 24 weeks, 52 weeks) & is used as a filter. So would need to be divided by that number after being filtered.

The time frames live in a seperate table ('Time Frame'), my inital thought was to add a column with each value's static number, but i don't know what formula to use to divide by that number after it's been filtered. 

For example - Total units/stores selling/# of items/4 weeks. Starter formula below:

Thanks for your help!

[v-zhangti]

Hi, @AndrewUrban 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

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