Forum Discussion

Regular Visitor

8 years ago

Solved

Weighted Distribution calculation

Dear all, I need help. I have a simple data model and have to calculate weighted distribution for products in stores per category. WSD Calculation is very simple – I should sum StoreSha...

Zubair_Muhammad

8 years ago

Try this MEASURE for the CARD VISUAL

WSD =
CALCULATE (
    [Store Share],
    SUMMARIZE ( Sheet2, Sheet2[Store], "Share", [Store Share] )
)

Super User

8 years ago

Hi,

Your question is not clear. Share a dataset, explain the business question and show the expected result.

iRuso
Regular Visitor
8 years ago
Hello,

This is link to my dataset and template
https://drive.google.com/file/d/1uy1fpaoC3eJkCeeGZSWT2QXeZmCzEpql/view?usp=sharing

Bussines case:

Weighted distribution for Retail.
We have 5 different products on sales in Retail Chain.
Total category sales calculation is very simple - CALCULATE(SUM([SalesVolume]); ALL())
Total Sales per Store also is easy - CALCULATE(SUM([SalesVolume]); ALLEXECPT(Table;Table[Store]))
The percent share of each store is calculated as Total Store Sales / Total Category Sales.
Now then one product is selected Weighted Distribution is Sum of Store Share only for stores where selected Product has been sold.
In my example only Product4 should have 100% Weighted distribution, but I got 100% for all items.

Could you please help me with correct formula?
- Ashish_Mathur
  Super User
  8 years ago
  Hi,
  
  I still do nto understand your question. Please show me what exact % are you expecting in the card visual when each store is selected.
  - iRuso
    Regular Visitor
    8 years ago
    Hello,
    
    For Product2 as showed above - Card Value should be 92.02.
    This Sum of store share values.
    
    Thank you in advance.

Related content