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.
negi007's avatar
negi007
Community Champion
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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your response! I found out that conditional formating is an easier workaround