Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Data Protection
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , seen like you are still creating a measure, not a table, that is why this error.

 

Also, I doubt you need to have some grouping involved at what level it should be >5. and that need a different approach

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for helping, amitchandak ! I changed the DAX expression to be in a "new table," but still am getting the same error.

 

I can't group the employee ID numbers; they need to be filterable many different ways. Maybe I'm misunderstanding?

  • v-yingjl's avatar
    v-yingjl
    Community Support
    4 years ago

    Hi Anonymous ,

    This error cause by if statement in Power BI. 

    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.