How to sum up a measure calculated by other measures?

[Anonymous]

Hi I have created a measure for [TTL score] = [A Score]+[B Score]+[C Score], while [A Score], [B Score] and [C Score] are all measures. All of [A Score], [B Score] and [C Score] are calculated dynamically. That is, for example, depending on the % reach rate: if >10%, score 10, >20%, score 20....

So far, for each target, the scores are well shown as below

Target	A score	B score	C score	TTL score
6600005120	10	30	40	80
6600005122	8	20	30	58
6600005128	15	30	20	65
6600005165	6	40	20	66
6600005187	10	10	30	50

However, I also need to know the overall average TTL score, and found can't simply apply AVERAGEX or SUMX to [TTL score] for calculation. Supposedly, it's because the measures are dynamic based on the information from each row and thus can't calculate the overall performance in this way....Is anyone has a solution for this??? Many many thanks 😄

[Gopal30]

You can try using Calculate function which changes it to filter context. something like this :

Calculate([TTL score])

[Anonymous]

hi @Gopal30 

thanks for the suggestion!!! but still it doesn't work...

Let me make my case more clear. The [total score] is applied in a table with other info, like below

No.	Supplier Code	Total Score
1	6600005311	62
2	6600007270	53
3	6600006463	14
4	6600005412	44
5	6600005766	36
6	6600005451	44
7	6600005187	86

But if i want to show the total (i.e. the aggregated=sum(No1~No7)), it'll go wrong with error "cannot display the visual"...I also tried to turn on the "total" function in Format, but it's the same error...please kindly help, thanks 🙂

[v-chuncz-msft]

@Anonymous ,

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M130947

[Anonymous · Accepted solution]

hi @v-chuncz-msft 

thanks!! I've figured it out and ended up using the same solution as you suggested 😄

Overall TTLScore =

SUMX(SUMMARIZE('Table','Table'[Supplier Code],'Table'[Suppliers],"TTL",[Total Score]),[TTL])

Still, thank you very much for the help!