How to display all the values in a dimension

[danimarc12]

Hello everyone!

I have the following issue: I want to create a simple table composed of a column with a dimension which has all the values of my dataset and a secon column with a measure which shows an "X" if the dimension has a data or "O" if not.

I'm gonna show you:

"Cliente" is my dimension but, as you can see, if I select an year from my filter, I'm gonna exclude the values with gray background. My goal is to display all of them and display in another column if they are in the year I select.

I hope I've been clear.

Best regards!

[stevejoyce]

Cliente can be your dimension.  Use this as your expression:

pick(count({1} distinct 1) * count( distinct 1) + 1, 'O', 'X')

[danimarc12]

I still can see the gray fields.

[stevejoyce]

ok in this scenario where you want to be able to filter also, you need to have this field dis-associated from the data model.

Create an island table like:

Cliente_island:

load 

Cliente as Cliente_All

resident <data source>

;

Then your object's dimension will be Cliente_All field.

And your expression will be:

pick(count({1} distinct 1) * count( {<Cliente_All  = P(Cliente) >} distinct 1) + 1, 'O', 'X')