max sales based on only category

[powerbiexpert22]

how to calculate max sales based on category and by ignoring month as shown below

sample data : 

https://docs.google.com/spreadsheets/d/1VaOgc2zCR_lbG8CCtYvH4JYkynYvlfZ5/edit?usp=sharing&ouid=10701...

pbix file: 

https://drive.google.com/file/d/1oGIwzyTC3FIjHbdwU5O_Jv6t0OXoWBSO/view?usp=sharing

[v-cgao-msft · Accepted solution]

Hi @powerbiexpert22 ,

Please try this measure:

Max Sales = 
    MAXX( 
        FILTER(
            SUMMARIZE(
                ALLSELECTED('Orders'),
                'Orders'[Category],
                'Calendar'[Month]
            ),
            'Orders'[Category]=SELECTEDVALUE('Orders'[Category])
        ),
        [TSales]
    )

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[fahadqadir3]

@powerbiexpert22 

Please review the attached screenshot, and use the following measure to sum based on Business Unit.

Measure Fixed = CALCULATE(

    SUM('Table'[value]),

    ALLEXCEPT('Table','Table'[BU])

BU Actual Total = 
CALCULATE(
    SUM('Table'[Actual]),
    ALLEXCEPT('Table', 'Table'[Business Unit])
)

Similarly, in your case you can use the following measure

MAX SALES= CALCULATE( SUM('Table'[TSales]),
               ALLEXCEPT('Table', 'Table'[Category) )