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]
)
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.

     

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      5 years ago

       

      Anonymous 

      You can use MAXX

      Attendnace = 
      MAXX (
        VALUES(WC_YEARS[YEAR]),
        [Highest Attendance]
      )

       Qualification = 
      MAXX (
        VALUES(WC_YEARS[YEAR]),
        [Highest Qualification]
      )

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Sorry, but the solution you provided didn't gave the correct answer.