I have a list of members and I have created a measure using Calculate to get the list of members who are life members.
I now want to display the life members as a table.
However when I select table and use my life member measure, I only get a number (13).
If I add my Member Name field to the table I now get my life members showing but I also have an additional column with the number 1 in each row - see graphic.
I don’t want the additional column called NZ Life Members. I only want to display the life members names in a single column.
I’m sure there’s an easy solution to this but I can’t seem to work it out or find a solution with Google.