Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Quick Measure Help - Sum-If function in PowerBI

Hello,   I'd like some help with a calculated (or a few?) field please. I have a simplified sample of the kind of data I'm looking at below. I have a list of branches, qty shipped on a date, and if...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You don't need to use quick measure, just create a measure directly.

    Try this measure

    Result =
CALCULATE (
    DIVIDE (
        CALCULATE ( SUM ( 'Table'[Ship QTY] ), 'Table'[Success Ship?] = "Y" ),
        SUM ( 'Table'[Ship QTY] )
    ),
    ALLEXCEPT ( 'Table', 'Table'[Branch] )
)

     

     

     

    Best Regards,

    Stephen Tao

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello,

     

    This wasn't really enough information. I understand how to rank and only show the top 10 values, but I need to calculate If Branch X, (Sum of Y) / (Sum of Y + N). Can you help to solve this? 

     

    Maybe it needs to be another table?

     

    Thanks for your help. 

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous , when you have not selected Success Ship in visual 

      Try measure  

      sum(calculate(sum(Table[Ship QTY]), filter(Table, Table[Success Ship] ="Y")), sum(Table[Ship QTY]))

       

      if Success Ship is in visual 

      Try a measure = 
      sum(sum(Table[Ship QTY]),calculate(sum(Table[Ship QTY]), removefilters(Table[Success Ship])))