Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX not working.

Hi. I have created 2 measures using same formula, but one of my DAX is not working and other is working fine. I have attached screenshots of the same.     Highest Qualifications and A...
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    So you need the year with the highest value:

    Qualification = 

MAXX(
    TOPN (
        1,
        ALLSELECTED (WC_YEARS[YEAR]),
        [Highest Qualification]
    ),
    WC_YEARS[YEAR]
)
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

The 2nd screenshot doesn't show the Qualification measure, you need to clear on it and share the screenshot.

You use ALLSELECTED(WC_Years[Year]) instead of GROUP BY

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Fowmy 

    ALLSELECTED() too is giving the same error.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      You are getting this error because the TOPN function is returning multiple values. There are multiple years for which the value is equal to Highest Qualifications. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Fowmy Anonymous 

        I just noticed that there are multiple year values for which the 'Highest Qualifications' measure is giving the same value.

        Do you guys know any DAX which will return only 1 year value.