agrregating currency based on users

[aka]

I want to develop a report in which the filter should only display the currency in which the employee has done transaction in i have a table shown

natural currency key -is the curreny id

how should i approch in order to achive the output?

NaturalCurrencyKey   SalesID       SalesTerritoryName    EmployeeID   CurrencyCode
             120                 9999                 Australia                  12                   CHF
             117                 1111                   india                      12                   SEK

output requried :- when employee id 12 is using the report he should only see the currency filter as CHF and SEK

no other currency which we have in the table

[v-caliao-msft]

@aka,

For your requirement, each employee should only see the currency in which the employee has done transaction, we can use Row-level security to achieve it.

In Power BI, Row-level security (RLS)  can be used to restrict data access for given users. Please refer to the link below to see how to set up RLS for your report.
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

Regards,

Charlie Liao