Forum Discussion

elliottgarner's avatar
elliottgarner
Frequent Visitor
9 years ago

Restrict column based off measure (?)

I have a table in one of my reports that looks like the following:   ID          Response                 Category          Location 1            This is a comment    Misc                   USA 2...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi elliottgarner,

Based on my understanding, you want to get the result as shown in the first screenshot when there are fewer than 10 comments in your original table. And when you have 10 or more comments in your original table, you want to get result as shown in the second screenshot. If that is the case, create two columns instead of measures using the following DAX.

Display1 = IF(DISTINCTCOUNT(comments[Response])<10,0,1)
Newresponse1 = IF(comments[Display1]=1,comments[Response],"Response Restricted")



Thanks,
Lydia Zhang

elliottgarner's avatar
elliottgarner
Frequent Visitor
9 years ago

Hey

 

Thanks for your reply - have just tried your suggestion and unfortunately I can't get it to work.

 

I think the issue I'm having is that there are other visualizations on the page that effect the number of displayed comments, and it's my understanding that a column won't update based off any filtering that happens on the report page? This train of thought was what led me to try and do it with a measure originally, as they do seem to update "on the fly".

 

Will keep playing around for now, I'm sure there's a way to get this working!

 

Cheers

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi elliottgarner,

     

    Could you please share the PBIX file so that I can reproduce?

    Thanks,
    Lydia Zhang

    • elliottgarner's avatar
      elliottgarner
      Frequent Visitor
      9 years ago

      That'd be great - I will strip out any confidential information when I'm at my computer tomorrow morning and get that sent through.

       

      Is there a preferred method for sharing .pbix files, can't seem to see a way to upload files along with my post?

       

      Thanks again!

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi elliottgarner,

        You can upload PBIX file to OneDrive, and post a shared link of the file on this forum.

        Thanks,
        Lydia Zhang