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 ca...
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.

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity 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.