Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Oct 28, 2015, 5:55 AM

How can I create a filter from multiple measures/dimensions?

Hi

 

I've edited my original message to be clearer regarding the question and attached an example workbook.

 

I'm trying to create a filter based on boolean dimensions. I'd like the filter to be a checkbox list, which a user can select one or multiple items to filter the data by.

 

In the example dataset the boolean dimensions are O_ACT, O_NSW, O_NT... there are 8 in total. I've tried using a parameter but there are too many dimensions.

 

Cheers

Stephen

Tableau question example.twbx
3 answers
  1. Sankarmagesh Rajan (Comcast india Engineering Center)
    Oct 28, 2015, 7:35 AM

    Hi Stephen,

     

    Want to select each measure in filter.

     

    We can create measure parameter and calculation and get single measure at a time.

    Step:1

    Create parameter [Measure Parameter] list as Sales, Profit and Unit Price

     

    Hi Stephen, Want to select each measure in filter. We can create measure parameter and calculation and get single measure at a time.

    Step:2

    Create calculation as follows [Measure Calc]

    case [Measure Parameter]

    when "Sales" then [Sales]

    when "Profit" then [Profit]

    when "Unit Price" then [Unit Price]

    end

     

    Step:3

    Drag this [Measure Calc] into column and drag any of dimensions into row

     

    Step:4

    Show Parameter control and select Kpis.

     

    Thanks

    sankar

Write an answer...
0/9000