Make a SUM of 2 measures in a different table

[Jorge_Dier]

Hi guys, I'm looking for some help with the following issue.

I've calculated the following visualization table using measures for each output MIN, AVG, MAX, Q1, Q2, Q3. 

Now I need to make an addition of those results per index, for instance, the 2 first lines have the index # 1, then I need to sum up the results of the MIN, AVG, MAX, Q1, Q2, Q3. Since the results comes from different measures, I'm not able to create a new visulization table grouping the results by index. Hope you can help me guys.

[v-jayw-msft · Accepted solution]

Hi @Jorge_Dier ,

Create measure as below:

sum_min = SUMX(FILTER(ALLSELECTED('table'),[index]=SELECTEDVALUE([index])),[min])

sum_avg = SUMX(FILTER(ALLSELECTED('table'),[index]=SELECTEDVALUE([index])),[avg])

...

etc.

Best Regards,

Jay

[jdbuchanan71]

@Jorge_Dier 

Why can you not just remove the extra fields and have index and the measures to get the view you want?

[Jorge_Dier]

That's a good question but the results are not the expected ones because each tag description has a different name.

Expected results: