Hi there, I have an issue with my data model. Bassicaly, I need to filter all my report according to the row filtered from one main table. In my example, I have 3 dimensions and 1 fact table :- DimSource- DimClient- DimProdut- DimSales The main table (DimSource) should be able to filter every table since a column named "SourceId" is available in every other tables. I made sure that all the data don't cross from one Source to an other : However, I'm not able to make it work, even though the data don't cross. Here's my model: I've tried using some RLS but I couldn't make it work. Any ideas ?

Why not merge all of these onto a single Query? Or make 2? Seems kind of overkill to need that many relationships when there aren't many unique columns

This is only an example to explain my problem/need.My real data model contains about 20 dim tables and 3 fact table soooo... I doubt this would be efficient if I merged everything in only one table 😋

Marfield You have to merge DimSource and Dimsales to filter the measure from sales by login. Also, to filter the dimensions, modify the filtering as bidirectional between client -Sales and Product-Sales. No need to have the source ID in Product and Client. If this helps, mark it as a solutionKudos are nice too.

Just try to make it active from the property and check what error it gives. I faced the same issue when I tried joining one table by (say ) source not by source Id. I deleted all such join and created all join on source IDs. Also make sure there are no two paths, which not visible here in diagram.

Why would that not be efficient? That is essentially what relationships are accomplishing. It would solve this issue 100%

One table to rule them all | Microsoft Fabric Community

12 Replies

Anonymous
Not applicable
6 years ago
Why not merge all of these onto a single Query? Or make 2? Seems kind of overkill to need that many relationships when there aren't many unique columns
- Marfield
  Helper I
  6 years ago
  This is only an example to explain my problem/need.
  My real data model contains about 20 dim tables and 3 fact table soooo... I doubt this would be efficient if I merged everything in only one table 😋
  - amitchandak
    Super User
    6 years ago
    Just try to make it active from the property and check what error it gives. I faced the same issue when I tried joining one table by (say ) source not by source Id. I deleted all such join and created all join on source IDs.
    
    Also make sure there are no two paths, which not visible here in diagram.
VasTg
Memorable Member
6 years ago
Marfield

You have to merge DimSource and Dimsales to filter the measure from sales by login. Also, to filter the dimensions, modify the filtering as bidirectional between client -Sales and Product-Sales.

No need to have the source ID in Product and Client.

If this helps, mark it as a solution
Kudos are nice too.