Data Modelling

[tsarun1992]

Hello all,

I've a data model which has multiple entries in the column "CRM" for a specific employee (Screenshot below)

My need is, only the latest CRM (Highest CRM Number) should be displayed for an employee.

What DAX should be used to meet my requirement. I tried with the below DAX but its not displaying the correct (highest CRM) value.

Max Values =

VAR maxValue =

CALCULATE(

    max(List[CRM]),

    ALLEXCEPT(List, List[Employee Name]))

    RETURN

    IF([CRM]=maxValue, "MAX")

Thanks a ton in advance whoever is going to spend time to resolve my issue 🙂

[tsarun1992 · Accepted solution]

Issue is resolved brother 🙂 The CRM column format was changed from TEXT to NUMBER, then it chose the largest value automatically using the same DAX

[johnt75]

for debugging try returning the maxValue variable. that will show whether it is retrieving the same value for everybody or a different value for different people and could help to indicate where the problem lies.