Forum Discussion
Dynamic categorization based on dynamic value
One way of acheiving this is through numeric range parameter: go to Modeling > New Parameter > Numeric Range to create a slicer. Note - this won't be dynamic, so you'll need to know the range of values for your Amounts. If that isn't really an option, then you can manually do the same thing by creating a calculated table with GENERATESERIES().
Then you can create measures such as
Below Threshold Users = COUNTROWS(FILTER(UserCodes, UserCodes[Amount] <= Parameter[Parameter Value]))to use in your pie chart.
One way of acheiving this is through numeric range parameter: go to Modeling > New Parameter > Numeric Range to create a slicer. Note - this won't be dynamic, so you'll need to know the range of values for your Amounts. If that isn't really an option, then you can manually do the same thing by creating a calculated table with GENERATESERIES().
Then you can create measures such as
Below Threshold Users = COUNTROWS(FILTER(UserCodes, UserCodes[Amount] <= Parameter[Parameter Value]))to use in your pie chart.