Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Summed Category * static weighted value

Hi all, I've been trying to figure this out for days now with no luck online. Hopefully someone can help me. So I have a data-set of numbers I'd like to sum up by category then another calculation...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , It should be table or some group level

     

    a measure

     

    sumx( Availability_Calculations,[Total %] * [Weighted_Values])

     

    or

     

    sumx( values(Availability_Calculations[Avail_Category]) ,calculate([Total %] * max([Weighted_Values]) )  )

  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.
    Initial data:

    Measure:

    Total% = DIVIDE(SUM('Table'[SubNumber])-SUM('Table'[TotalNumber]),SUM('Table'[SubNumber]))
    Weighted% = SUM('Table'[Weight])*[Total%]/100
    Measure = SUMX('Table',[Weighted%])

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous 

 

You can try the following methods.
Initial data:

Measure:

Total% = DIVIDE(SUM('Table'[SubNumber])-SUM('Table'[TotalNumber]),SUM('Table'[SubNumber]))
Weighted% = SUM('Table'[Weight])*[Total%]/100
Measure = SUMX('Table',[Weighted%])

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for the reply both!

If I use amitchandak  calculation of "sumx( values(Availability_Calculations[Avail_Category]) ,calculate([Total %] * max([Weighted_Values]) )  )" it shows up correctly on both the weighted% total and values and if I use v-zhangti other calculations it works hand in hand for the other sections! Thank you both!