Using a filter based on Multiple columns that can filter the whole report page ! including Measures

Hi Anonymous ,

This is a double post on your previous topic I think --> LINK

What I was going to answer there was that you will need to unpivot. I understand it is difficult and you need to rethink your datamodel design, but since you are working with Measures it should be possible but you'll need to change the measures you have. On the other hand, what you absolutely can do is this:

In your original query, add an INDEX column. (Power Query Editor, Add Column ribbon, Index Column. Then duplicate the query and do the trick I showed you in your other topic (creating the three columns). Then unpivot and remove all columns except the Index column and the Value column (with all possible values). Then create a relationship between your original Query index column and the new query index column. Then use the the second query in your slicer and that should filter your original table (and keep your measures intact). 

Let me know if it works!

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂