We’re stuck with Power Bi and we’re ready to drop the idea of developing our reports with Power Bi. But I decided to describe our problems here, so maybe someone can help us. We started with 10 original custom reports developed with some old reporting technology. New reports should retain old filtering, which is StartDate, EndDate and few IDs. We also decided to pull all the relevant data into one huge view, so business users can pick whatever columns they want and filter with any of these columns (meaning that they can utilize all PowerBi possibilities). Some reports need some sort of calculated tables. That huge view has several measure columns. So, these calculated tables are created with UNION, e.g.:
We have problems to filter such tables, meaning that if we create a visual with those 2 measure columns straight out of the huge view, we can filter them with other columns from the view (by creating a slicer tied to that column). But the visual created with our “Union” calculated table is not responding to changes in the slicer, i.e. we can’t filter that calculated table. It seems that these calculated tables are sort of a “snapshot” and that they can’t be filtered in real time.
If this is true, does anyone has a suggestion how to take some smaller subset of data from that huge view and create a visual from that smaller subset, that is filterable with slicer tied to any column from the original view?
I have tested it on my lecal environment, we can filter the data by using slicer. TestTable = UNION(ROW("Category","Test1","Test11",'Table'[Measure]),ROW("Category","Test2","Test22",'Table'[Measure 2]))
Thank you for the reply. We can also filter with columns from that exact calculated table (just like you did), but we want to filter with columns from the original view, from where the calculated table gets calculated. When we try to create a slicer that has a column from the original view , we can't filter the calculated table.