Forum Discussion
Haroon95
7 years agoRegular Visitor
Relationships
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...
v-chuncz-msft
7 years agoCommunity Support
Haroon95
7 years agoRegular Visitor
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?
- Anonymous7 years agoNot applicable
What grapic(s) are you trying to create? One to Many should not be an issue for representing the data / using slicers...
- Haroon957 years agoRegular Visitor
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