Filtering data based on measures

[sujeet_shirude]

Hi everyone,

I have a data set similar to attached. I have created a master measure for sum(Sales Amount). In a table, I want to be able to enter greater than, less than or equal to value in the sum(Sales Amount) and filter the data. 

What will be the best way to do this? 

Any insights on this would be appreciated. Thank you!

Regards,

Sujeet Shirude

[SerhanKaraer · Accepted solution]

Hi Sujeet,

You can convert an expression into a dimension with the help of Aggr() function.

Aggr(sum(Sales Amount),yourDimensionsToCalculateExpression)

By this way you can provide filtering option for users.

[sujeet_shirude]

Thanks a lot, Serhan!

It worked.