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=107010240500343952141&rtpof=true&sd=true

 

pbix file: 

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

 

 

 

 

 

Need Help

2 Replies

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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