Modeling data

[Syndicate_Admin]

Hello, good afternoon

I'm importing 2 boards with a relationship between the two n:m

however table1, after filtering, I know that your data is unique. therefore after that filtering (performed in powerquery) it would become 1:n

However, despite this, in relationships it still tells me that it is n:m

My choice is to leave it at that, knowing that after powerquery filtering, it will be 1:n

is there any way to import the filtered information already?, for example in the action "navigation"?

Thank you

[v-luwang-msft · Accepted solution]

Hi

You could  calculate a new table B(filter from table A) ,then create relationship between table B and table C.And wish the following article is helpful for you!

CALCULATETABLE
Create and manage relationships in Power BI Desktop

Here are some similar threads for your reference:

Pre-Filtering Data before Importing

Filetring my table before importing in PowerBi

Best Regards

Lucien