Forum Discussion
filter a summarised table by date
Does that table has Month, Then use that as a filter. I think I am confused now. Please explain the issue with an example.
All the visuals are based on measures
Have you created a separate measure table and referring to that. This means a dummy table with the only measure.
In that, case your measures will respond to the filter of the tables they belong too.
If you have created a summarized table without a date or month, then you have to create it with a date. You can take month start date to group data at month level and join it with the date table.
Right, 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.
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?
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]))
