Correct row totals in visuals when applying several filters

[Anonymous]

Hi,

I'm having problems getting a correct row total on a field.

I researched a bit and it appears to be a known problem.

I've been looking at some solutions, while still struggling with the syntax to be honest, but it's not working.

My main problem is that there are several filters applied to the page.

Let me describe the setup:

Table "Sales"

Field to total: "ActualSales" (decimal) from the underlying data source Sales

Filters:

- Each page is for a different Sales Agent, so there's a SalesAgent field and a page filter on SalesAgent is being applied to all Visuals (specific value per page)

- There is a month filter on a calendar (also applying to all visuals on the page), filtering out the month(s) on InvoiceDate

What measure(s) should I use so that get a correct total of ActualSales?

Thx a million for your help!

[Sahir_Maharaj · Accepted solution]

Hello @Anonymous,

Can you please try this:

Total ActualSales = CALCULATE(SUM(Sales[ActualSales]), ALL(Sales))

By using the "Total ActualSales" measure with the ALL function applied to the Sales table, you can disregard the filters on the SalesAgent field and the month filter while calculating the total. This should provide an accurate total of ActualSales, considering all the data in the Sales table, regardless of the filters applied on the page.

Do not hesitate to let me know if you might need further assistance.