Forum Discussion
decimals displaying incorrectly when applying RLS roles
The problem is a bug that seems to have a relationship to DirectQuery, row level security, page filters, and data volume. There is a page level filter being applied that constrains the results to records from the current month when the following logic returns "TRUE"
My Filter = MONTH('Date[Transaction Date]) = MONTH(TODAY()) && YEAR('Date[Transaction Date]) = YEAR(TODAY())
The above was created as a field that was added to the Page Filters and constrained the results to records returning "True". When this filter was removed the problem went away but there was no other way to achieve the required data set without this filter. Through trial error I eventually discovered that also adding the filter field to the table itself fixed the problem. I was then able to squeeze the width of the column to be so narrow that it was not noticable when placed at the far right of the table.
I hope this fix to this obscure problem benefits someone some day. I expended a great deal of time figuring this out. Let me know if you have encountered this too.
The problem is a bug that seems to have a relationship to DirectQuery, row level security, page filters, and data volume. There is a page level filter being applied that constrains the results to records from the current month when the following logic returns "TRUE"
My Filter = MONTH('Date[Transaction Date]) = MONTH(TODAY()) && YEAR('Date[Transaction Date]) = YEAR(TODAY())
The above was created as a field that was added to the Page Filters and constrained the results to records returning "True". When this filter was removed the problem went away but there was no other way to achieve the required data set without this filter. Through trial error I eventually discovered that also adding the filter field to the table itself fixed the problem. I was then able to squeeze the width of the column to be so narrow that it was not noticable when placed at the far right of the table.
I hope this fix to this obscure problem benefits someone some day. I expended a great deal of time figuring this out. Let me know if you have encountered this too.