Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Danfountain
Helper I
Helper I

Getting data from an unrelated table

Hi

 

These are the tables i current have

 

Users 
UserListExchange Rate
Dom\ABC1230.123
Dom\zzz1120.789
Dom\SDF3121.2

 

UserBU 
UserBU
Dom\ABC1231
Dom\ABC1232
Dom\ABC1233
Dom\zzz1121
Dom\SDF3121
Dom\SDF3123

 

Sales  
OrderNumBUTotal Value
12100
23500
31100
41200
51300
53600
63

1000

 

So the user table has row level security to bring back the details of the user.  This then applies a relationship filter to the User BU table to find the BU`s a user can see.  Then from there it applies a relationship based on BU`s to show the sales within the BU`s that a user can see.  Hope that makes sense.  It seems to work.

 

Now my problem is i have exchange rate in the user table.  I want to use this to convert the each total value into the users exchange rate.

 

It doesnt seem to matter what i have tried it never seems to bring back the value filtered by the RLS in this table.

 

To begin with i am just using this to create a column

Weighted_LocalCurrency = min(User[exchangerate])
 
But the value isnt the same that is in the RLS filtered table for the user.  I just cannot work it out 🙂
 
Any ideas?
 
Dan
0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.