Forum Discussion
Solved
Dynamically generating a table using OR filters, then aggregating it in a measure
I have a report where my stakeholders want to know the distinct count of a field based on if ANY of a given number of dimensions apply, rather than if they ALL apply which is default PowerBI filter b...
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.
You cannot materialize a calculated table from a measure.
Oh, thank you! Now I realise why I was getting stuck 🙂 is there any way that I can do what I need to apart from having it in a measure? Do you have any suggestions for how I can do it with a data set as big as mine?
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.