Forum Discussion

Marfield's avatar
Marfield
Icon for Helper I rankHelper I
6 years ago

One table to rule them all

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 ...
Need Help
VasTg's avatar
VasTg
Icon for Memorable Member rankMemorable 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.