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.

       

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