Filtering Values

[Kate_D]

Hello. I an trying to create yes/no slicer based of responses provided to surveys. The issue is that some surveys have received both responses and no responses due to multiple respondents assigned. When filtering the surveys based on whether responses have been provided or not, the same survey gets returned marked both yes and no (Ex. Delta and Netflix as shown in the table below).  In other words, I am trying to get back the surveys that received zero responses and surveys that have been answered at least once. Thank you!

[Anonymous · Accepted solution]

Hi @Kate_D ,

The Table data is shown below:

Use the following DAX expression to create a column

Column = 
VAR _Survey = [#Survey]
VAR _result = COUNTROWS(FILTER('Table',[#Survey] = _Survey && 'Table'[Responded Yes/NO] = "YES"))
RETURN 
IF(ISBLANK(_result),"NO","YES")

Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.