Forum Discussion
Calculated table ignoring filters on original table
Hi everyone,
In my project I have a table (PerformancePerDay) with data from multiple types of entities. Now I'm trying to create calculated tables (for instance PerformancePerTransportType) based on that original table with 1 'grouptype' filter. The original table has a date column on which i have a slicer to select data from a specific year. What I'm struggling with right now is that when I create the second table using this dax CALCULATETABLE(PerformancePerDay,PerformancePerDay[GroupType]="TransportType") , I only get rows of TransportType but while the original table is correctly filtered on year, in my second table I get data from all dates.
The reason for these tables is so that I'm able to show data in a grid for that type and to be able to drill through to another page where the category needs to be a filter on yet another table.
Things I've tried already:
* use of keepfilters
* using measures to get selected year and use that in the filter for creating the table
* creating the tables through powerquery editor (preselecting on type there) and adding the required relations
Schema is as follows:
3 Replies
- JirkaZ
Solution Specialist
You need to understand that tables created using DAX (going to Modeling -> New Table) are updated only during a data set refresh and persisted in memory that way.
You can then work with them just like with any other table (create relationships, measures, calculated columns).
Ok, but I can't create a relationship from TransportTypePerformance to both date and GroupageOrder dus to ambiguity, so is there any other way I could solve this riddle?
- JirkaZ
IMHO what you want to achieve doesn't require any calculated tables. A standard drillthrough setup with maybe some extra filters should do it.
