Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like a dimension (not a calculated dimension) to ignore a specific filter. I understand the syntax for ignoring filters in a measure or calculated dimension but this has me stumped.
As an example, I have a Client filter and a Client dimension in a table however I do not want the table to change when a user selects a Client name in the filter.
Any ideas?
Hi Daniel,
I also encountered the same situation, and find it difficult to do it in expression.
I am planning to load duplicated variables when loading data, and supposed by using the duplicated variables, the dimension in the table will not change when filtering.
You may also have a try.
Have you tried using an aggregation function like Concat() with set analysis to ignore the dimension?
Hi Daniel,
I have one idea, you can use Straight table, add necessary dimensions and instead of real expressions add simple expression with set analysis, for instance: sum({<Client=>}1). In my example I use column type
After this you will have table with necessary data and this table will ignore selections in the Client filter.
Also straight table provides possibility to hide columns, so you will hide you measure sum({<Client=>}1)
See screenshots below.
Presentation Tab
Added expression and select 2 in type column - table shows all data that I have
Hide measure column and select 1 and 2 in type column - table still shows all data.
Thanks,
Vitalii