Forum Discussion
Drillthrough based on disconnected table
I have a model where there is a fact table of transactions, a date table (related to fact table), and a disconnected date table (used for filtering). The model structure is like the below: ...
bcdobbs Thank you so much for your suggestion! I tried the first one:
VisualFilter =
VAR SelectedMonthEnd = SELECTEDVALUE ('DisconnectedDate'[MonthEndDate] )
VAR Result =
CALCULATE (
INT ( NOT ( ISEMPTY ( Transactions ) ) ),
'Date'[MonthEndDate] = SelectedMonthEnd
)
RETURN Result
I put that measure on a card and saw that it does accurately change 1/0 based on selection. However, when I added it as a filter on the drillthrough visual, the drillthrough did not filter correctly. When a date is selected from the slicer, the drillthrough is blank. Do you have any suggestions?
bcdobbs
Community Champion
Community ChampionCan you share your updated pbix. Will have a look.