Hi All,
Let me give a brief description of my setup.
I have a FACT table with [contract] and [id] columns.
I have several DIM tables with each an [id] column.
Created a BRIDGE, where I added all the DIM table [id] columns and created a relationship between FACT and DIMs(many) to BRIDGE(one).
My report has several pages, each displaying data from a specific DIM table.
On page 1 I have a slicer, filtering by fact[contract] and fact[id].
On page 2 I want to propagate the slicer selection on page 1, specifically the [id] to display data from corresponding DIM table.
My FACT table has all [id], and each DIM has only it's corresponding [id]s so on page 1 I have to filter by fact[id] and not bridge[id] otherwise not all the [id]s show up in my slicer.
On page 2 I cannot sync my slicer (I've added it to the same slicer group but to no avail).
The two workarounds I've found are:
1) add a table visual, added fact[contract] and bridge[id].
when I click on the [id] all my card visuals display the correct info.
2) created two measures: first -> selectID = selectedvalue(fact[id])
second ->
card measure = CALCULATE(
MAX('dim1'[abc]),
FILTER('dim1',
RELATED(bridge[id]) = [selectID]
)
)
The issue with the first workaround is that I always have to click on [id] in the table visual I created for the filtering on the cards to take place.
Issue with second workaround is that I would have to create a measure for each card/column to apply the [selectID] measure, so let's say 1 card has dim1[abc], another card dim1[123] etc etc.
Is there a way I can apply the [selectID] measure to all visuals on page 2, basically using the measure as a page level filter?
Thanks in advance for any input.
