Forum Discussion
Summarize applying filters
Hello,
I'm trying to filter a calculated table using a slicer.
Let's say that I have an existing table (TABLE 1) with a list of sales of each article, the date of the sale and the total amount:
| Article | Date | Amount |
| Apple | 01/01/2023 | 10 |
| Watermelon | 02/01/2023 | 20 |
| Apple | 04/02/2023 | 50 |
| Grapes | 05/03/2023 | 15 |
| Apple | 25/02/2023 | 6 |
| Watermelon | 07/02/2023 | 24 |
I have a slicer controlling the period of time in order to calculate the SUM of 'Amount'. In this case the slicer is set between the 01/02/2023 and the 31/12/2023. The result of the SUM will be then 95.
I will then create a second table (TABLE 2) that will summarize the articles using the following code:
SUMMARIZE(TABLE1,TABLE1[ARTICLE],"Amount",SUM(TABLE1[Amount]))
| Article | Amount |
| Apple | 66 |
| Watermelon | 44 |
| Grapes | 15 |
As it can be seen the 'Amount' of the TABLE2 is not the good one because the filter is not applying to the SUMMARIZE. Can I obtain the good amounts taking into account the filter ?
2 Replies
Calculated tables are always populated when the data is loaded so don't respond to report filters.
You need to use a measure to sum the amounts and then drop it and the article name into a table visual which will do the summarising for you live respecting filters.
So even if I create a relation between TABLE1 & TABLE2 the TABLE2 will never be updated when I'll modify the slicer ?
