How to divide different column total while keeping slicer functionality?

[ltruong7]

Hi there,

I am currently calcuating the cut_qty divided by the sum of the original_order_qty field in order to get the FR impact by row which shows the correct result in the first row at .29% however, when I adjust my timeline slicer based off of the week/date the calculation still uses the sum of the original_ord_qty of all values instead of the specific values within the time range I've selected. I want to be able to look at the FR impact for a given timeframe, for example in the second picture I provided below, I want the cut_qty to be divided by 869,889 but the current calculation is dividng 869,889 by 16,655,086 (1st picture)

Calculation based off of total timeline

Calculation based off of 1 week within the year

[Ashish_Mathur]

Hi,

Try this measure

=SUM(Fill_rate_Data[cut_qty])/CALCULATE(SUM(Fill_rate_Data[Original_order_qty]),ALL(Fill_rate_Data[Original_order_qty]))

Hope this helps.