Summing all the values from a summarized table in DAX removing any filter context

[Anonymous]

Hi.

I'm trying to calculate a measure which contains the Pareto value based on my TOP 20 Products.

I'm trying to create a virtual table what will contain an agreggation by product of the money losses of the company (using SUMMARIZE) and then I wish I could filter all the data in this table based on the products that have a column "LOSS" greater or equal than my current measure on the row context. 

The problem is since it's a virtual table I can't use CALCULATE directly and when I try to use SUMX() the row context is applied and I only get my current measure value avaliable on the virtual table.

Is there anyone who knows how to solve this problem?

[Anonymous · Accepted solution]

Hi @Anonymous,

Perhaps you can try to use summarize function in variable to reproduce the current virtual table with specific field groups, then you can use iterator function summary these values.

All the secrets of SUMMARIZE - SQLBI

Measure Totals, The Final Word  

Regards,

Xiaoxin Sheng