Forum Discussion
Helper IIICustomer Categorization based on Revenue
Community ChampionYes noticed that. I'll see what I can do.
regarding the location, it is the same. If unselect the location then it will consider the classification as overall. Unless you need to show at the same report
Helper IIICan this be happen the new category filter can be made which shows only classification for overall without selecting any location.
- tamerj1
Actually if no location is selected the current measure shows the category considering all locations is one location . If you one location is selected it will show the category based on the selected location. If you select 2 locations then the selected locations bwill be treated ae one area. And so on. It is fully dynamic. If you want a seperate measure that does not change when selecting locations then please let me know.
- apatwal
Measure can not be used as filter visual. Can it possible to create calculated column.?
I need to show Categorisation as filter visual.
- tamerj1
Actually calculated column is much simpler. But it won't be dynamic (for example in terms of date) we can consider the classification for each year separately for example but you cannot choose any time period and find the classification of the customers baes on that period. While the solution I provided it completely dynamic. (Let me know if you are interested in that)
However, as per the current approach you can use a slicer from the category table to slice both revenue and number of customers. If you are interested in other measures using this approach please let me know. Otherwise confirm shifting to the static classification with calculated column and advise if you need this classification to be for all times or foe each year.