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.

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.

gruskowska's avatar
gruskowska
New Member
1 year ago

HI - thanks for the post.  Unfortunately I'm getting 404 file not found when I try to download your example file.  Would it be possible to repost or include the formlas the main post. Thanks!