Forum Discussion
Post Patronfilter a summarised table by date
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.
Post PatronI 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: