Grand total doesn't filter

[Anonymous]

I get the wrong total when I try to filter through the following:

I have three tables;

- Bomlines containing the quantity of ingredient (itemreq) of a sold item

- Sales table containing the sold item

- Item table, containing unique item keys 

With the following relation:

In order to calculate the total amount a an ingredient sold to customer X. 

I use the following formula:

Sum(SalesForecastVerijkt[AantalOmzetHE])*sum(Bomlines[quantity])

When I apply a filter on the on Sales Table; the total amount of a ingredient is still equal to the total amount when the filter is not applied. So somehow it is still active. 

Can anyone help me out on this? 

[Nathaniel_C]

Hi @Anonymous ,

So the filters are being applied on each row, but total means there is no filter.  So try ALLSELECTED in your formula, which should make the Total row sensitive to the filter.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel