Forum Discussion
Solved
Single date slicer to filter multiple date tables
I'm hoping this isn't actually so difficult, but I've had a tough time trying to figure out the proper setup. I'd like to use a single date slicer to filter multiple tables with dates in them. The ta...
Shouldn't your slicer be based on the dates in a Date Table where the Date field is related to all of the relevant date fields in your other tables?
Hey Mate,
try adjusting the cross filter direction to both. You currently have the cross filter direction to single.
Aree, thanks , i have made the change but there was not difference. Below are the measures being calculated for display in both tables Total Subscriptions = Calculate( CountRows(qmInvestmentLogs), qmInvestmentLogs[InvType] = "Subscription",qmInvestmentLogs[TranStatus] = "Success") Total Approved Customers = Calculate(CountRows(qmCustomers),qmCustomers[KYCStatusDesc]= "Approved") Total Subscription Amount = Calculate(Sum(qmInvestmentLogs[Amount] ) ,Filter(qmInvestmentLogs,qmInvestmentLogs[InvType] ="Subscription" && qmInvestmentLogs[TranStatus] ="Success") ) Total Redemptions Amount = Calculate(Sum(qmInvestmentLogs[Amount] ) ,Filter(qmInvestmentLogs,qmInvestmentLogs[InvType] ="Redemption" && qmInvestmentLogs[TranStatus] ="Success") ) All work well but the Total Approved customers.