Forum Discussion
Post Patronfilter a summarised table by date
Post PatronAll the visuals are based on measures
Community ChampionRight, but we have no idea what your measure formulas are so kind of hard to know if they would respond to filters by month.
But in any case, try changing the Cross filter direction between your circled table and your Tipulim table to Both. Even though there is no common field between the tables, if Calendar filters Tipulim and Tipulim filters your circled table, then Calendar ultimately filters your circled table.
The other thing that you can do is to build the relationship directly into the measure. In other words, use something like:
VAR __Month = MAX('Calendar'[Month])
You put that in your measure and now you can use ___Month variable within your measure to do filtering, etc.
- gtamir
Greg_DecklerI did the first thing, it filters but wrongly. The number of customers is correct, but other values are wrong. I think it will never work.
You see, the summarised table contains other calculated columns based on the original transactions table. They will not be filtered.
I think I will have to do a different project every month.
What do you say?
- gtamir
I continued to investigate.
I put on the visual of the filtered page all the fields of "RunningTotalByMetupalim". The table is filtering the names for the last month,
but the column "Total" gives the total of all the unfiltered table. This is why all the table is wrong.
The summarised table is:
RunningTotalByMetupalim = SUMMARIZECOLUMNS(Tipulim[Metupal Name], "TOTAL" , SUM(Tipulim[Total]))