Group Matrix into Dynamic Quartiles

Hi Anonymous ,

Ritaf1983 , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution: 

I am using the financials table provided by power bi as sample data.

1. create MEASURE to get the ranking of current sales.

MEASURE = 
VAR _rank =
    RANKX ( ALLSELECTED ( financials ), [_sum_sales],, ASC, DENSE )
RETURN
    _rank

2. Create MEASURE to display different names based on the rank.

Measure2 = 
VAR _max_rank =
    MAXX (
        SELECTCOLUMNS (
            ALLSELECTED ( financials ),
            'financials'[Product],
            "_Measure", [MEASURE]
        ),
        [_Measure]
    )
VAR _g1 =
    DIVIDE ( _max_rank, 4 )
VAR _g2 =
    DIVIDE ( _max_rank, 2 )
VAR _g3 = _g1 * 3
RETURN
    SWITCH (
        TRUE (),
        [MEASURE] <= _g1, "G1",
        [MEASURE] > _g1
            && [MEASURE] <= _g2, "G2",
        [MEASURE] > _g2
            && [MEASURE] <= _g3, "G3",
        [MEASURE] > _g3
            && [MEASURE] <= _max_rank, "G4"
    )

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.