How to get max value from quartal

[yellowold5]

Hi all, I need help some help with this, I need to find the max quartal value, see example:
IDCategoryQuartalvaluerank

1	A	1	22	1
1	B	1	21	2
1	C	1	20	3
1	D	1	20	4
1	A	2	20	1
1	B	2	20	2
1	A	3	19	1
1	B	3	19	2
1	C	3	19	3
1	A	4	19	1
1	B	4	19	1

My desire output is only display is the rank column then i can show the max value each quartal.

[Anonymous]

Hi @yellowold5 ,

In addition, you can refer the following links to get it.

Rank Unique - ranking when there are duplicate values

Power BI – Handling Duplicate Rankings using RANKX DAX Function 

RANKX WITH DUPLICATE VALUES IN POWER BI | RANK RETURNING DUPLICATE VALUES 

Best Regards

[Anonymous · Accepted solution]

Hi @yellowold5 ,

I created a sample pbix file(see the attachment), please check if that is what you want.

Calculated columns:

Column = 
VAR _id = 'Table'[ID]
VAR _quartal = 'Table'[Quartal]
RETURN
    RANKX (
        FILTER ( 'Table', 'Table'[ID] = _id && 'Table'[Quartal] = _quartal ),
        'Table'[Category],
        ,
        DESC,
        DENSE
    )

Rank = 
VAR _id = 'Table'[ID]
VAR _quartal = 'Table'[Quartal]
RETURN
    RANKX (
        FILTER ( 'Table', 'Table'[ID] = _id && 'Table'[Quartal] = _quartal ),
        'Table'[value] & 'Table'[Column],
        ,
        DESC,
        DENSE
    )

Measures:

RankCat = 
VAR _id =
    SELECTEDVALUE ( 'Table'[ID] )
VAR _quartal =
    SELECTEDVALUE ( 'Table'[Quartal] )
RETURN
    RANKX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[ID] = _id
                && 'Table'[Quartal] = _quartal
        ),
        CALCULATE ( SELECTEDVALUE ( 'Table'[Category] ) ),
        ,
        DESC,
        DENSE
    )

RankFlag = 
VAR _id =
    SELECTEDVALUE ( 'Table'[ID] )
VAR _quartal =
    SELECTEDVALUE ( 'Table'[Quartal] )
RETURN
    RANKX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[ID] = _id
                && 'Table'[Quartal] = _quartal
        ),
        CALCULATE ( SUM ( 'Table'[value] ) + [RankCat] ),
        ,
        DESC,
        DENSE
    )

Best Regards