Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use Same Filter for Multiple Columns

Hi,   I was wondering if there was a way to create a slicer for the same month and day, but used for different columns in a table. In my table, there are two different dates. One for Inititated Mo...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    I have created a small example.

     

    With USERELATIONSHIP you can switch the relationship for a measure.

    https://docs.microsoft.com/en-us/dax/userelationship-function-dax

    You may download my PBIX file from here.
    Hope this helps.

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Good Morning Dong ,

 

I have created the Slicer table as you showed:

Slicer = DISTINCT(UNION(DISTINCT(Query1[Init Month and Day]),DISTINCT(Query1[Repaired Month and Day]))), named Month and Day, and also the measure named Filter in Data: 
Filter in Data = CALCULATE(COUNTROWS(Query1),FILTER(Query1, Query1[Init Month and Day] IN FILTERS (Slicer[Month and Day]) || Query1[Repaired Month and Day] IN FILTERS (Slicer[Month and Day])))
 

I am struggling understanding how to use this filter, because I believe that there is no link between the above column and measure and the table 'Query 1' , so when using Month and Day as the field for the Slicer filter, it does not filter the tables as seen in the screenshot below...

 

Thank you so much!
Sarah 

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

could you share a screenshot of your model view?

Is there only one Measure in your Matrix?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Good Morning mwegener !

    I am new to Power BI... is this what you mean for model view?

     

    The original table with Init Month and Day and Repaired Month and Day are in the Query1 table... I have been trying to play around and created the Datess, Dates, and Slicer tables and have tried linking them, but I cannot seem to create the correct link so that my filter filters for both Init and Repaired Month and Day...

     

    Thank you so much!
    Sarah

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Also, mwegener 

     

    There is only one measure in my matrix, as seen below

     

     

    Thank you!
    Sarah

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Hi Anonymous ,

       

      I have created a small example.

       

      With USERELATIONSHIP you can switch the relationship for a measure.

      https://docs.microsoft.com/en-us/dax/userelationship-function-dax

      You may download my PBIX file from here.
      Hope this helps.

       

      If I answered your question, please mark my post as solution, this will also help others.

      Please give Kudos for support.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi mwegener 

        This may be a dumn question, but how do you create the Value column in your query table?

         

        Thank you!
        Sarah