Forum Discussion
Dynamically generating a table using OR filters, then aggregating it in a measure
As soon as you want the result to be influenced by user input you can only use a measure. If your measure is not performing well enough then you need to work on improving it's performance. There is a 1M row limit for this.
Yes, but. You cannot materialize a calculated table from a measure. You can only use a table variable as part of the measure calculation. The final output of the measure needs to be a scalar value (like the distinct count).
You need to use disconnected tables to feed your slicers, and then in your measure use TREATAS or equivalent to read the selected values from the slicers and implement your OR logic.
Note: To implement OR logic on a single column you can use KEEPFILTERS.
I've given more info here: https://community.fabric.microsoft.com/t5/Desktop/Dynamically-generating-a-table-using-OR-filters-then-aggregating/m-p/4269380#M1341296 thank you 🙂