Relationships

Haroon95 · ‎06-19-2019

Hi

I have 2 tables, a "product master file", which contains all information about all products, and a "Forecast error table" which has calculated absolute error in Excel. They are connected by a product key.

In the "forecast error table, the product key occurs 1 time, and same in the Product master file.

But the Power BI says the relationship is "many to one", which is wrong. My data wouldnt match with the product keys from the Product master table, until I changed the cross filter direction to "both" (is was set as "single" by Power BI).

My question is; why cant I channge the cardinality to 1 to 1?

Thnx

v-chuncz-msft · ‎06-20-2019

@Haroon95

The cross filter direction can only set to ‘Both’ for one-to-one relationship.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Haroon95 · ‎06-26-2019

Hi

Thats strange.

Because I have to choose "both" on cross filter direction, and power bi allows me only to choose many to one cardinality, even though every product number occurs 1 time in each table...

Any idea why?

Anonymous · ‎06-26-2019

What grapic(s) are you trying to create? One to Many should not be an issue for representing the data / using slicers...

Haroon95 · ‎06-26-2019

I am creating a table. But when i use single it does not summarize pr row in the measure. The output is the total sum. After I change it to both, it starts giving sum pr row, and total sum at the bottom.

Regards