Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX Query Correction

i m trying to get the text value from country table based on a condition and a maximium value in nobel prize data table. Below is my dax query that need to be corrected . waiting for your  respons...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

please try

Country By Max Nobel Prize In Literature =
VAR LiteratureTable =
    FILTER (
        ALLSELECTED ( 'Nobel Prize Winner Data' ),
        'Nobel Prize Winner Data'[category] = "Literature"
    )
VAR MaxShare =
    MAXX ( LiteratureTable, 'Nobel Prize Winner Data'[share] )
RETURN
    CALCULATE (
        MAX ( 'Country Table'[Country] ),
        'Nobel Prize Winner Data'[share] = MaxShare,
        CROSSFILTER ( 'Country Table'[Country Abbrevation], 'Nobel Prize Winner Data'[Country Abbrevation], BOTH )
    )