Forum Discussion
Sum and filter
Hi All, I have a question on my data. Where I need to sum up the amount based on the ID’s and filter for that amount greater than or equal to 1,00,000(Threshold). I have tried but I can add at a...
Yes, you could create a measure that is your threshold.
Measure = 1000000
Then have all of your other measures and visuals do their filtering based on that measure. You could even use a What If Parameter to do this.
Not sure I am 100% clear on your requirements though.