Forum Discussion

stevezly's avatar
stevezly
Icon for Helper I rankHelper I
4 years ago
Solved

Median giving incorrect values

Hi All,    I am trying to calculate median over some grouped data, but the "median" value I get back is the same for each group which cannot be correct. Am I missing something here?   Thanks   ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    It would be returning the median across the entire dataset, it wouldn't be split into any categories.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Ah, I don't know enough about RLS to be able to help with that.

stevezly's avatar
stevezly
Icon for Helper I rankHelper I
4 years ago

I do find it strange though, that the RLS works fine when I use the summarize function in a calculated column, but it doesnt when i use it as a variable table.

 

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    Are you sure that RLS is being applied to the calculated table? The table would only be calculated during data refresh, so I don't think that RLS would come into effect - there wouldn't be any logged in user at that point

  • stevezly's avatar
    stevezly
    Icon for Helper I rankHelper I
    4 years ago

    That's why I'm using the calculated table; to bypass the RLS filter. Although it seems like there is no solution to my problem as these calculations are incompatible with the slicer.