Forum Discussion
Weighted Distribution calculation
Hi iRuso
Try this MEASURE for the CARD VISUAL
WSD = CALCULATE ( [Store Share], SUMMARIZE ( Sheet2, Sheet2[Store], "Share", [Store Share] ) )
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?
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.
Hello,
For Product2 as showed above - Card Value should be 92.02.
This Sum of store share values.
Thank you in advance.
Hi iRuso
Try this MEASURE for the CARD VISUAL
WSD = CALCULATE ( [Store Share], SUMMARIZE ( Sheet2, Sheet2[Store], "Share", [Store Share] ) )Great !
It was easy. Thank you a lot!