Forum Discussion
stevezly
Helper I
Helper IGlobal Benchmark while using RLS
I'm not sure this is something that is possible but I am seeing mixed responses on forums so far so thought I should ask myself here. I am trying to create a summary table that calculates medians...
stevezlyHelper I
Helper IHi All,
Been stuck on this for more than a week now. Would be great if someone could help.
I need to be able to show the global median of some KPIs, while RLS is switched on, so each client can see a benchmark to compare their data to. I have tried a summarized column and also static column, using data entry for the aggregations but of course neither of these work as they cannot be filtered by the slicers on the report, which I also need to work.
Really struggling to believe there isn't a solution for this. If there is it's not intuitive- if someone could point in right direction that would be great.
Thanks
S
stevezlyHelper I
Helper IJust bumping this up, seems to be a lot of action this morning.