Roles and subtotal

[Christof_27]

Hi,

1st, sorry for my english, i m french.

I want to know if it s possible to use roles (Region 1 only data R1, Region 2 only data R2 ...) and put subtotal with sum of all Region data. It s reference and important to see this data for them.

I put screen shoot for explain my question.

Ty

[tringuyenminh92 · Accepted solution]

I haven't tried this case but it's so lucky to have new topic from sqlbi.com about this scenario:

http://www.sqlbi.com/articles/implement-non-visual-totals-with-power-bi-security-roles/

Hope that topic could fit your need.

[Christof_27]

Ty for your link.

I duplicate my table with data and remove columns i dont need. I use this one for my aggregate values.

It seems same solution but i want to know if i dont ignore existing function.

Ty again