Want to create calculate table by taking max value for a column

[sarjensystems1]

Hello All,

I am looking for a dax to create a calculate table having max value for every "distinct key". In the very first picture after applying filters for single distinct key i am getting 2 rows just because of IndirectcontractpriceToday having 2 values.

[Fowmy · Accepted solution]

@sarjensystems1 

You can create a table as follows:

Table 1 = 

FILTER(
    ADDCOLUMNS(
        'Rebate Copy',
        "Maxvalue", 
            VAR __MAX = CALCULATE( MAX('Rebate Copy'[indirectcontractpricetoday]) , ALLEXCEPT( 'Rebate Copy' , 'Rebate Copy'[Reate Key]] )) 
                RETURN
                IF( 'Rebate Copy'[indirectcontractpricetoday] = __MAX , __MAX)
    ),
    [Maxvalue] <>BLANK()
)