Forum Discussion

richrich123's avatar
richrich123
Helper III
6 years ago
Solved

Filtering out 'non responses'

Hi all,   Im struggling to find a way to see a list of customers who havent submitted any survey responses. Im sure there must be a way but Im struggling to find one that works.   I send out a su...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Yes.  [Score] is correct (my bad).  Also, since that must be a numeric column, the "" isn't working.  You can replace that part with >0 (or >-1, if you expect 0 Scores in the data) in place of the <>"".

     

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

    Regards,

    Pat

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi richrich123 ,

 

You can try to create a calculated column or measure and apply it to the visual level filter.

Measure = IF(CALCULATE(HASONEVALUE('Table'[Description]),ALLEXCEPT('Table','Table'[Client Name])),1,0)

I created test pbix based on the screenshot you provided.

 

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

  • richrich123's avatar
    richrich123
    Helper III
    6 years ago

    Hi V-lianl-msft ,

     

    Many thanks for your help. I tried this and it isnt right. I dont have the account name and identifier for a response (score) in the same table. Your .pbx example does exactly what I am after but the measure isnt working for me, I think due to the relationships.

     

    In the Dynamics npssurveyresults entity, everyone who has been sent a survey has a new record created and the score only has a value if its been returned so if score = blank, no survey returned

     

    Is there a way to do this by ross referencing the measure bewteen accouns to look at client names and scorees from the npssurveyresults table?

     

    Many thanks