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

Anonymous — Mon, 09 Oct 2023 14:57:21 GMT

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?

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

Anonymous — Wed, 11 Oct 2023 00:53:21 GMT

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

topic Re: Summing all the values from a summarized table in DAX removing any filter context in DAX Commands and Tips

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

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