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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors