Forum Discussion
Filter aggregated table with direct query datasource
Hi, I have a report built on a direct query data source. This report contains a table with products and a measure, let's say sales. This table can become very long with hundreds of products. How...
ToddChitt
Super User
Super UserAh.OK. You will probably need to change the Filter Direction of the relationship to "Both". This will allo wthe FACT table (Sales) to 'filter' the DIMENSION table (Products). Then create a Parameter (not a Power Query parameter) as available on the Modeling tab. You will need to use the SELECTEDVALUE DAX function to get the value selected by the user. Work that into you filter on Sales