agrregating currency based on users

Question

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 shownnatural currency key -is the curreny idhow should i approch in order to achive the output?&nbsp;NaturalCurrencyKey&nbsp; &nbsp;SalesID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;SalesTerritoryName&nbsp;&nbsp; &nbsp;EmployeeID&nbsp;&nbsp; CurrencyCode&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9999&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Australia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; CHF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 117&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;india&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SEK&nbsp;output requried :- when employee id 12 is using the report he should only see the currency filter as CHF and SEKno other currency which we have in the table

v-caliao-msft · Answer

aka,
&nbsp;
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.
&nbsp;
In Power BI, Row-level security (RLS)&nbsp; 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/
&nbsp;
Regards,
Charlie Liao

Forum Discussion

agrregating currency based on users

1 Reply

Related content

Currency FX Rates

Dynamic currency conversion based on Account Manager location in Power BI

Dynamic currency exchange based on currency selected by the user

PowerBi Desktop Currency format

Function currency conversion