Single date slicer for multiple queries

[masongalindo]

Hello!

I know this has been asked before, and I followed the instruction that was provided but seem unable ...

I have a pretty simple dashboard with only a few tables. Basically, I need a single date slicer to drive multiple queries. The attached shows how I have my relationships setup and the error I am receiving. I am unable link both the Traffic and FlashSales tables to the Calendar table. It only allows one relationship to be active at a time, yet, this causes the slicer to drive only one query or the other, and I need it to update both.

All help greatly appreciated 🙂

[MattAllington · Accepted solution]

Turn off bidirectional cross filtering and it should be ok. Double click on the double arrows on the relationships and change there

[masongalindo]

@MattAllingtonYou nailed it. Thanks!

[CheenuSing]

Hi @masongalindo

There are couple of approaches to handle this.

1. Explore if the two fact tables Flash Sales and SMS Traffic can be combined as a single FactTable with a column called TransType which will have values like "Flash" or "SMS". And then connect this to single Calendar Table. The only caveat is your measures will have to have additional filter to include this new column TransType.

2. The second approach could be to make use of USERELAATIONSHIP function when referring to the SMS Traffic table.

     Eg : SumTrafficCount = Calculate (SMSTraffic[TrafficCount], USERELATIONSHIP(SMSTraffic[Date], Calendar[Dates])

Share some data and the outputs you expect. 

If this works for you please accept it as a solution also give KUDOS.

Cheers

CheenuSing

[masongalindo]

Hello @CheenuSing

Thank you for the help. I actually attempted Matt's solution first because it seemed quicker and it did the trick. I'll keep your advice in mind as well, thanks for taking the time to help me.