Filter the dimension value similar to explicit selection in a filter
Hi All,
I am working on an issue where the dimension value had been moved from one category to another which work as expected when I select a filter explicitly. But have used a inline load to pass the filter value in an expression and the dimension value is not getting filtered out, details on the aforementioned scenario in below -
Dim1 has a value India, England, America.
Dim 2 has A, B ,C
I have a year selector (as a Inline load ) which had multiple values
Dim1 and Dim 2 are used in a Pivot table with expressions where am getting year as a filter (using inline load).
When I select Year = 2022 A was suppose to display only in India and when I select Year = 2021 "A" was suppose to display only in England.
But when am selecting 2022 using inline Year selector A is coming under both India and England. Am unable to filter value A explicitly for selected year value
{< Year = {AnyValue}>} or {< Year = p(IslandYear)>}
reflects always the availability of the selected respectively here defined values. This means it's a column-level evaluation. A comparison on a row-level is not possible in this way. In some cases you may bypass this restriction by nesting set analysis and/or combining multiple ones but the complexity will increase quite heavily and therefore it's far more common to solve such challenges rather with if-loops.
In regard to your case it's not really clear for me what didn't work like expected. Please share some screenshots of your object and the results by the various selections - and how your expected view would look like.
And please also post all dimensions and expressions you are using in the chart object. It's hard to help with a lot of information missing.
Besides this, do you get aggregates (the result of your expression(s)) for the 'wrong' combination of dimensional values? Or just empty cells? In this case, also check that all expressions you are using (also for formatting) are including the set expression with your year filter.
