Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Weighted Distribution calculation

Hello,   Could you please help me to calculate weighted distribution using DAX? I have the following table:   Client Products Sales 100042 product1 24 100070 product2 20 100070...
Need Help
  • affan's avatar
    affan
    7 years ago

    Hi Anonymous,

     

    Please see the attached PBIX file update with your requirement. I have created a calculated column to calculate your desired result.

     

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan

     

     

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Hello Anonymous

 

You just need to apply the filter within CALCULATE

 

CALCULATE( <your sum measure>, Products[Product] = 'Product1' )