Forum Discussion

Kratos_ZA's avatar
Kratos_ZA
Helper I
3 years ago
Solved

Categorizing a calculated measure

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!

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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