Forum Discussion

iRuso's avatar
iRuso
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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi iRuso

     

    Try this MEASURE for the CARD VISUAL

     

    WSD =
CALCULATE (
    [Store Share],
    SUMMARIZE ( Sheet2, Sheet2[Store], "Share", [Store Share] )
)
iRuso's avatar
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. 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi iRuso

 

Try this MEASURE for the CARD VISUAL

 

WSD =
CALCULATE (
    [Store Share],
    SUMMARIZE ( Sheet2, Sheet2[Store], "Share", [Store Share] )
)
  • iRuso's avatar
    iRuso
    Regular Visitor
    8 years ago

    Great !

     

    It was easy. Thank you a lot!