Forum Discussion
Anonymous
3 years agoNot applicable
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...
- 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]) ) )
- 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%]/100Measure = 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.
amitchandak
Super User
3 years agoAnonymous , 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]) ) )