Forum Discussion

fraz's avatar
fraz
Regular Visitor
3 years ago

Visual filter breaking drill-through

I've got a drill-through page that isn't working when a particular visual filter is added and I don't know why.  A simplified dataset where I've recreated the problem is here.   Data The IDs of ...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

When I ran the internal SUMMARIZECOLUMNS from the filter,

SUMMARIZECOLUMNS(
'Transactions'[Appeal Code],
'Transactions'[Campaign Code],
'Customers'[Customer ID],
__SQDS0FilterTable,
"Communication_Count", IGNORE('Measure Table'[Communication Count]),
"CountRowsTransactions", CALCULATE(COUNTROWS('Transactions'))
)

I got an empty table back. There don't appear to be any transactions which match campaign C1