Survey Plain Text Data - Setting Minimum Response Threshold
Hello everyone! I've got a puzzler here that I'd love to get some perspective on.
As part of a larger survey results dashboard, I have created a table visualization that shows plain text comments associated with individual identifiers. The visualization is filterable many ways. In some cases, a user would be able to filter down to fewer than 5 individual respondents, which exposes people's identity. This is the challenge I'm trying to fix.
For individual measures, I have a good solution:
Census - Inorganic Growth Employee Count = var result = DISTINCTCOUNT('Census - Inorganic Growth'[Empl ID])
Currently as far as I know, if statement not support to return table or multiple columns as expressions result. If statement should return a specific sclar value instead of table value. In addition, Power bi not support to create dynamic calculated column/table based on filter/slicer.
Best Regards, Community Support Team _ Yingjie Li If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.