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