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() ))
parry2k Error on my part. Apologies.I had a filter applied to only select a certain grade which I didn't apply to the DAX query. Is there a way to add another filter for e.g. for grades E2, E3, E3L,& R2,R3,R3L & U2,U3, U3L
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] = "E2")
),
CALCULATE(
COUNT(Sheet1[Company_Id] ),
ALLSELECTED() )))
Anonymous you can do something like this
FILTER(Sheet1,Sheet1[Intake_Data_Grade] IN {"E2","code", "Code", "Code", "Code"})
Anonymous glad to help. on other note, you marked your own reply as solution .
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() ))