Forum Discussion
Problems with Max() and RLS/Using Max() with RLS to filter Summarized table
Anonymous this is totally different issue, you need to look at this aggregation approach instead of what you are doing. it is not a correct approach.
Anonymous I don;t know why you are using MAX etc, here is the expression:
Trans-summ-Issue =
SUMMARIZE(Transactions,Transactions[Company ID],
"Rev4200",[TotalRev4200],
"Rev4500",[TotalREV4500])
and here is the output
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hello parry2k,
thank you for your response.
I need the "max" part since I get the error which I stated in the question above.
The dataset I provided is just a simplified model with much less data.
Best regards
Anonymous did you saw the result I posted, is that what you are looking for? If not then let me know what the output suppose to me.
parry2k yes, it works in the model which I provided. But it does not work in my real model because there are too much rows to
calculate.
This is a screenshot with the error from my real model.
This is why I need to limit the summarize function to this single company. If I don't limit the function, I get the error.
As far as I can see the problem is that the max() statement does not respect the RLS limitations. Is there any solution to this?
Thank you
Anonymous this is totally different issue, you need to look at this aggregation approach instead of what you are doing. it is not a correct approach.