Forum Discussion

Advocate III

6 years ago

Filtering fact table based on unrelated dimension table

Hi, I want to filter a fact table based on a dimension table that is not related in a pure star schema data model. A snippet of the model looks like this: I know that ideally, you...

Need Help

camargos88

Community Champion

6 years ago

Hi rhl94 ,

You can use the TREATAS function if you don't have a relationship:

https://docs.microsoft.com/en-us/dax/treatas-function

Also, you can create a inactive relationship between them and active it in your measure:

https://docs.microsoft.com/en-us/dax/userelationship-function-dax

parry2k
Super User
6 years ago
rhl94 question, what would be logic to filter the table? There are many ways to do that but provide some data and example and it will help to provide a suitable solution for the scenario. Information you provided is too vague.

Forum Discussion

Filtering fact table based on unrelated dimension table

Related content

degenerate dimensions

RLS Filtering additional dimensions

Remove filters from a dimension

RLS on multiple dimensions

Filtering across multiple dimensions