How to filter a table using a measure

Question

Hello, I need some help on how to filter a table using a measure.&nbsp; I need to create a table from a filtered table, but I created a measure that captures different slicer values and that is what I would like to use to filter. Here is my code for the filtered table I would like:SELECTCOLUMNS(FILTER('Revenue by Region','Revenue by Region'[Customer]=[Selected]),"Customer",'Revenue by Region'[Customer]))So the [Selected] is my measure, but this currently returns an empty table.&nbsp; My measure does work correctly so the issue is just when I try to filter based on the measure. I even selected a specific customer to filter by and replaced my measure in the code and that seemed to work fine as well, so the code and measure work independently just not together.Any assitance would be greatly appreciated.Thanks.

d_gosbell · Accepted Answer

Calculated tables are only evaluated during a data refresh operation. They cannot take slicer selections into consideration as slicers can only operate after the data refresh has finished.

So you'll need to look for a different solution to whatever problem you are trying to solve as a calculated table is not the correct approach if you need to use selections from slicers. You'll need to look at some measure based solution.

Forum Discussion

How to filter a table using a measure

2 Replies

Related content

Filtered table

Dynamic measure filtering

Filter by Rank measure

Temporary table with filters, measure in matrix

Can I filter the 1st fact table which then filters a 2nd fact table?