Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help needed!! Data anonymization

Hi all,    I recently made a Dashboard that displays the results of a survey distributed throughout the company.    The Dashboard allows users to drill down into the survey results using multiple...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • negi007's avatar
    negi007
    5 years ago

    Anonymous   I think it is possible, please do the following. If you have less or equal to 3 responses then "No Result" will be shown else orginal response will be shown on the visual

     

    1. Create a calculated column 

    Response_New = if (DISTINCTCOUNTNOBLANK(Tab[Response_Orginal]) <=3 ,"No Result", Tab[Response_Orginal])
     

     

    In case you wish to combine condition basis multiple columns, you can modify the dax above as well.
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Thank you for sharing the workaround. Would you please consider Accept it as the solution to help the other members find it more quickly?

 

Thanks for your understanding and support.

 

Best Regards,

Dedmon Dai