Set Analysis to Ignore Selections

[greend21]

Can anyone figure out why this isn't working? Am I missing something obvious? I have a chart based off information on the CompletionTimes table. I added list boxes for QueueNameCT and ModuleCT. I want selections for QueueName and Module(from the AssignedWorkflows table) to be ignored. I have the below measure but any selections made in the QueueName or Module listboxes affect this chart. Any ideas?

Count({<Module=,QueueName=>}DISTINCT WorkflowID)

[sunny_talwar]

Would you be able to share a sample to test this out?

[duncanblaine]

Try the following:
Count({<ModuleCT=,QueueNameCT=>}DISTINCT WorkflowID)

If you have list boxes for ModuleCT and QueueNameCT then they will be the selected fields you need to exclude in the Set Analysis.

Hope this helps

[greend21]

I want the chart to to filter when selections are made on ModuleCT or QueueNameCT. I don't want it to change when selections are made in Module or QueueName which are on other sheets.

[greend21]

Unfortunately I don't think I can. I put this in the below expression in another chart just to see if it would restrict QueueName selections and it worked as expected. I'm really not sure what is stopping it from working in the original scenario.

Count({<AssignedCompleted={Completed}, QueueName=>}WorkflowID)

[sunny_talwar]

Where are you using this? Can you post the images with and without selection to show the issue?

[greend21]

No selection

With Billing selected(from the list that I DON'T want to impact the chart).

[sunny_talwar]

Hahahahaha, so your expression is right... all you need to do is to ignore selection in your color expression ... What expression are you using for color?

[greend21]

Auto colors. I thought it shouldn't reflect any changes based on the selection?

[sunny_talwar]

Do you have a calculated dimension by any chance?