Forum Discussion
Helper IIIPage filter that affects two columns
Helper IIIHi MFelix , thank you for your help so far! I've tried opening your .pbix file, unfortunately my desktop version is older than yours and as I'm on a corporate computer I cannot update.
Below is a screen shot with dummy data of what the view currently looks like.
Your code looks like it would allow me to work around and make this work with a single filter/slicer, but I am getting the following error:
**** EDIT****
Code now works when I replace the semi colon with commas.
So, your solution works, but seemingly only if I can move all my sums to the new table. But there are lots of columns people want to filter by and I can't move them all to the new table.
Super UserHi Saarek ,
The error you are getting is related with regional settings you need to change the dot comma ";" by "," and it will work fine has you refer.
Not understanding the part below:
So, your solution works, but seemingly only if I can move all my sums to the new table. But there are lots of columns people want to filter by and I can't move them all to the new table.
The new table does not need to have any other data than the TIERS using the measures you are maknig the relation between the tiers and the calculations, what you can do in order not to have several measures that need to be redone based on the tiers you can use calculated groups.
But can you show a mockup of your data tables? That way I can adjust the process if needed,