Forum Discussion

Varun51's avatar
Varun51
Regular Visitor
6 years ago
Solved

MAXX DAX Function Help

HI ,

 

I am trying to get Max of sales for each category in a cross tab  .below is the sample data  i tried using MAXX but no luck

 

any help would be highly appreciated

 

Sample

 

Need to calculate max per each category here below case cateogry X should get  70 and category Y should get 200 in Crosstab

Category   Year   Sales

X             1998    50

X              1999  70

 

Y      1998      100

Y       1999      200

 

Thanks

Varun

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Varun51 ,

     

    Try this:

    CALCULATE(
    MAX(table[Sales]),
    ALLEXCEPT(
        talbe,
        talbe[Category]
    )
)

    Or this:

    Measure = 
MAXX(
    SUMMARIZE(
        talbe,
        talbe[Category],
        "Sales", MAX(table[Sales])
    ),
    [Sales]
)

    Many methods can be used to find the maximum value in groups.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Put Category in a table visualization, you can just use MAX([Sales]), no need for MAXX.
  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Varun51 ,

     

    Try this:

    CALCULATE(
    MAX(table[Sales]),
    ALLEXCEPT(
        talbe,
        talbe[Category]
    )
)

    Or this:

    Measure = 
MAXX(
    SUMMARIZE(
        talbe,
        talbe[Category],
        "Sales", MAX(table[Sales])
    ),
    [Sales]
)

    Many methods can be used to find the maximum value in groups.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.