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] )
)
Ashish_Mathur's avatar
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'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!