DAX calculation for Total of selling stores RRS feed

  • General discussion

  • Hi,

    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.

    any idea? 



    Tuesday, May 7, 2013 8:30 AM

All replies