Adding Set expression in dimension field to ignore selection

[VaishnaviMogal2]

Hi,

I have a table of 4 columns, Date, Parameters, changes and dash_count. all are dimensions. This table is filtering when i select Parameters from another table but i want to show data of all parameters in this table ignoring the selection made in Parameters. i am trying to add {<Parameters=>} . but it is not giving result as all fields are dimensions. How can i solve this?

Any suggestion would be helpful.

Thank you.

[Rohan]

Hi @VaishnaviMogal2 ,

Use the Set modifier =1, something like this :

sum({1<Parameters>}exp)

Regards,

Rohan. 

[VaishnaviMogal2]

@Rohan Thanks for reply but as I mentioned all fields are dimensions in table so I can't use SUM(expr)

[Rohan]

Hi @VaishnaviMogal2 ,

I meant in that table, there must be some measure right ? If not. then simply apply an alternate state to that table, the selections won't impact the given table.

Regards,

Rohan.

[VaishnaviMogal2]

which would be the better solution

1.using  Alternate state

2. creating measure, adding this set exp and hiding this measure(by giving text color white)

[Rohan]

I would prefer 2 because it'll be easy for my maintainance & understanding. But if the user is downloading the table then will you be ok with the measure being shown there ?

Regards,

Rohan.