Forum Discussion
Filtering out 'non responses'
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
Thanks for providing the diagram. Since there is a 1:1 between Contacts and surveys, you could try this measure:
Needs Follow Up = var countofresponses= calculate(countrows(mercury_npssurveyresults), mercury_nspsurveyresults[Response]<>"")
return if(isblank(countofresponses), "Y", "N")
This assumes you'll have a Table visual with the Name column from the Accounts table.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Hi mahoneypat ,
Thanks for the revised suggestion. I don't have a field called response. I have one called Score which is either null if no response or has the given numner (1-10) if they have responded. Assuming that was the one you meant?
I have swapped response for score and tested but get an error
Error Message:
MdxScript(Model) (4, 115) Calculation error in measure 'mercury_npssurveyresults'[Measure 2]: DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
Thanks
Rich
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
mahoneypat, fantastic, all working - much appreciated!