Hi community,
I am working on a report and the two columns that concern my measure now are CUSTOMER and FLEET.
The thing is that one customer can have many fleets, and I want to display the fleet name/s on the front page; that said, it would be nice to have the possibility to select different fleets and still show the selected fleets.
I have slicers on every page for users to select customer and/or fleet.
So my first idea would be if there is any way to select a customer and display on a measure the fleets related to it.
Second step would be if it would be possible to display the fleets, in case a user wants to select fleets (and not customer) that are not related to the same customer.
My first approach was to create different measures for each fleet and try to "rank" them, so I could select the first one in the first measure, then the second one... and create kind of a column on the first page to try and display them.
Hope it makes sense; I am of course openned to any other solution that you think could work.
Thanks in advance 😄
