Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

max sales based on only category

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=10...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
fahadqadir3
Icon for Solution Supplier rankSolution Supplier
2 years ago

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) )