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

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

 

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
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]
)