Forum Discussion
Divide with Filter
Quick question, I'm trying to get the % of cold weight cattle by a particular weight (between 16 & 21 kg) I've followed the divide by filter as indicated in the following forum thread:https://communi...
Anonymous you can do something like this
FILTER(Sheet1,Sheet1[Intake_Data_Grade] IN {"E2","code", "Code", "Code", "Code"})Got it! Thank you so much! I owe you one!
Cold Weight =DIVIDE(CALCULATE(COUNT(Sheet1[Company_Id]),filter(Sheet1,Sheet1[Intake_Data_Cold_Weight] >=16 &&Sheet1[Intake_Data_Cold_Weight] <=21),FILTER(Sheet1,Sheet1[Intake_Data_Grade] in {"E2","E3","E3L","R2","R3","R3L","U2","U3","U3L"})),CALCULATE(COUNT(Sheet1[Company_Id] ),ALLSELECTED() ))
Got it! Thank you so much! I owe you one!
Cold Weight =
DIVIDE(
CALCULATE(
COUNT(Sheet1[Company_Id]),
filter(
Sheet1,
Sheet1[Intake_Data_Cold_Weight] >=16 &&
Sheet1[Intake_Data_Cold_Weight] <=21
),FILTER(Sheet1,Sheet1[Intake_Data_Grade] in {"E2","E3","E3L","R2","R3","R3L","U2","U3","U3L"})
),
CALCULATE(
COUNT(Sheet1[Company_Id] ),
ALLSELECTED() )
)
Anonymous glad to help. on other note, you marked your own reply as solution .