Forum Discussion
Customer Categorization based on Revenue
Hi, Need to create a filter visual customer category based on Revenue. Category are based on parent customer's revenue (which is the aggregate of all its child customers) i.e. aggregating invoic...
You should review the following DAX Patterns, I think they will lead you to a solution
Static segmentation – DAX Patterns
Dynamic segmentation – DAX Patterns
You might also be able to solve it in your data pipeline before it gets into the PBI model. Here is my Blog post that looks into different ways of doing segmentation Dynamic Segmentation – Kevin Arnold
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!