Forum Discussion
Help with a measure needed
Hi,
I have solved a similar question in the attached file.
Hope this helps.
Hi Ashish,
I definitely think this is very similar to what I'm trying to achieve, thank you - are you able to help me understand how to map this across to my data to work for me?
In my data, the Force name column is the equivalent of your Unique ID, because each name is different, and that is what I want to display in my slicer for people to select from. The Model column is the equivalent of my Region column. So when a user selects the Force name (unique ID), I want it to display all the Force names (Unique IDs) from the same Region (Model). I don't think I have an equivalent of your Location column, because the Force name is the Location too...
Also, I don't know if it's relevant, but I have multiple datasets in my report which all have the Force/Region columns within them, so I'm hoping the solution is one that uses my D_Forces table which is linked to all the other datasets, so I only have to set up the measures once and they can be applied to everything?
Any further help would be greatly appreciated, thank you!
Hi,
After studying my solution, please try to solve it on your own.
Not a particularly helpful response as if I could solve it myself I wouldn't be on here asking for help!
I have managed to recreate what you've done in my own data, but I had to add an additional table for the unique ID, and add a unique ID column to my D_Forces table.
While the table then filters just like yours does on a separate page, I don't think this solution translates into the report I've already built as none of that uses the new Unique ID table/colums I had to add to replicate your solution.
If anyone knows how I can achieve the same result using my existing tables/fields so that it works with my existing report, that would be amazing.
