Calculating A Basic Count when criteria is met for 2 columns of data

[Anonymous]

I have measures to calculate based on a column's data of Yes or No.  I have a total count of a letter that is sent out, and based on the actions responded by the employee they are captured in 3 columns of data - value1, value2, value3 and each are set to Yes or No values.  Example if Value 1 mean letter recieve, Value 2 Means letter response received, and Value 3 employee reports the letter

My calculation for individual columns for yes is :  V1_YesCount = Calculate([TotalLettersSent],LetterTable[Value1] = "Yes)

I now want to only have a total count (# of employees) that said Yes for Value1 and Yes for Value 3.

[simrantuli · Accepted solution]

Hi @Anonymous,

Try the below measure.

V1_YesCount = Calculate([TotalLettersSent],Filter('LetterTable', LetterTable[Value1] = "Yes" && LetterTable[Value3] = "Yes"))

Best Regards

Simran Tuli

[Anonymous]

Thank you, that was perfect!!

[mahoneypat]

Please try this expression

V1V3_YesCount = Calculate([TotalLettersSent],LetterTable[Value1] = "Yes" && LetterTable[Value3] = "Yes")

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat