I am new to DAX and I will be glad if someone can help me with this:
we have data table including sales of products on stores by weeks.
I try to calculate Numeric Distribution, this is number of Store/Weeks selling specific product. I use DISTINCTCOUNT(data[StoreWeekID]) where StoreWeekID is unique combination of store and week. This works great.
Now I need to calculate Weighted Distribution, which is total sales of that Stores/Weeks = Total Sales of all products on stores / weeks, where the product was sold.
If NumericDistribution is 1 = only one store in one week sell that product, then WeightedDistribution is total sales of that store in that week.