Forum Discussion
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...
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.
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.