Categorizing a calculated measure

[Kratos_ZA]

Hi Friends,

Can you please help me with categorzing a measure.

Example.

1. I have a calculated measure from the 'Agents" table called [Orders Completed]. This is the sum of orders completed per agent.

2. I have a Region table with Regions which is joined to the Agents table.

3. I want to Create a matrix which has the number of agents per region that did 1-4 orders, 5-8 orders completed etc. Sample of what I want it to look like:

Can you please help me with the DAX and any other information on how I can do this?

Thanks very much!

[Anonymous · Accepted solution]

HI @Kratos_ZA,

I'd like to suggest you create a segmentation table with these ranges and use on matrix visual. Then you can write a measure formula to calculate value based current segment group:

Dynamic segmentation – DAX Patterns

Regards,

Xiaoxin Sheng